Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Time Dimension - Cannot filter on 31 Dec 2000

 
   Database Help (Home) -> OLAP RSS
Next:  Installing IDS 11.5 on Solaris x86  
Author Message
Justin

External


Since: Aug 12, 2008
Posts: 4



(Msg. 1) Posted: Mon Dec 08, 2008 8:26 am
Post subject: Time Dimension - Cannot filter on 31 Dec 2000
Archived from groups: microsoft>public>sqlserver>olap (more info?)

I have a cube in Analysis Server 2005 with a time dimension. One of my
measures has data for the date 31 Dec 2000. If I 'filter' in the cube browser
on this date I get no data.

If I remove all measures and attempt to filter the Time dimension on 31 Dec
2000 it does not display a row for 31 Dec 2000. Instead it shows a row for 01
Jan 2001 which has become selected in the filter drop down.

So I created a fresh cube pointing at Northwind. Built a cube on the Orders
table and a Server time dimension. If I filter that time dimension on 31 Dec
2000 whilst running a SQL Profiler the MDXQuery is as follows...

CREATE SESSION
SET [Northwind].[{072EF838-5749-4389-A414-83361581E5F5}Pivot4Hier11] AS
'
VISUALTOTALS(
HIERARCHIZE(
{
[Time].[Date].[All],
[Time].[Date].&[2001-01-01T00:00:00]
}
)
)
'

Again 31 Dec 2000 has been replaced with 01 Jan 2001.

Is there some kind of date issue with 31 Dec 2000 or am I missing something?

 >> Stay informed about: Time Dimension - Cannot filter on 31 Dec 2000 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
time dimension - Hi, I got inventory fact table, which I need to view by a time dimension. Problem is, its data is not on a single granularity: For the past two weeks, I got on a daily level; beyond that, weekly level, and at some point beyond that, monthly. I need to ti...

Time dependent Dimension - i have a dimension named 'CUSTOMER CLASSIFICATION' which depends upon the sales of the customer when the sales increases class changes for e.g from A to C it means the customer can have more then one class depending upon sales I have to maintained the....

4 weekly period within time dimension - Is it possible to generate a four weekly period within the time dimension? Or do you happen to know the accurate name of the attribute which does this within the server generated time?

Binding to time dimension - changing granularity - Hi All, I have a problem which probably has a standard solution, since its probably faced by many people: I have an inventory table (that is the source for a bunch of measures) and a time dimension. users would like to see inentory by time, which is..

Newbie q: How to add Hour/Minute to Server Time Dimension? - Using Sqlserver 2005 beta of a relational table in Oracle 9i. The table contains date/time fields with resolution down to hour. There's no time hierarchy in the database, so I wanted to use the Server Time Dimension facility of AS. I can make a cube..
   Database Help (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]