Master calendar without linking tables

[#1]

Hi there,

I am newbie here and need some help.. I have multiple date fields, talking bout 30 different date fields in several huge tables, and i need to use them all in our budget table.

I vs tried to concatenat them bu there is too much data and difficult to manage them.. Is it possible create a unlinked calendar and then use that calendar with variables to display the data in a table/pivot chart?

Please check the example qvw and help))):

Thanks in advanced..

[khadeer]

If u have 30 date fields, i think there is one r two major date fields, give the association any one of them with master calander date field. It will work for all.

[#3]

Hi,

It doesnt work or i couldnt do it.. Could you please send me a qvw?

[khadeer]

Hi PFA.

[#5]

Thanks for the document but i doesnt help me. Probably i couldnt explain my problem..

When i link my order date, as major data, with master calendar, i can not show the orders cancelled yesterday.. I can only show the orders made yesterday and cancelled at any time..

below you can find an example..

orderid	Orderdate	ApprovedDate	CancellatioDate	ReturnDate	Amount
1	09.11.2012	25.11.2011	-	02.12.2012	10,00
2	15.11.2012	-	01.12.2012	-	35,00
3	18.11.2012	03.12.2012	-	05.01.2013	80,00
4	12.12.2012	18.12.2012	-	02.01.2013	140,00
5	15.12.2012	06.01.2013	18.01.2013	-	65,00
6	05.01.2013	08.01.2013	-	03.02.2013	15,00
					345,00
Requested Table	November	December	January	February	Total
Orders	125,00	205,00	15,00		345,00
Approved Orders	10,00	220,00	80,00		310,00
Cancelled Orders		35,00	65,00		100,00
Return Orders		10,00	220,00	15,00	245,00

[#6]

Any idea??

[Anonymous]

If you have one Master Calendar, it can be linked to one of the dates.  So, the question is - what you expect to see by selecting January 2013?  Created orders? Cancelled orders?
There are several ways to deal with it, depending on what you actually need.  For example, create separate calendars for OrderDate, ApprovedDate, etc.  Or, create on calendar not conected to anything, and use logic in expressions, comparing any type of date (for example by set analysis) with the selected in calendar.

Regards,
Michael

[#8]

Hello Michael, thanks for your answer.

Actually i should be able to see both.

I ve tried to do the second option, calendar not connected to anything.. and that s where i need help.. As you can see from my sample data, my variable doesnt work.. and dont know why...

Best regards..

[rwunderlich]

Take a look at the tutorial "Using Common Date Dimensions and Shared Calendars " at http://robwunderlich.com/tutorials/.

The tutorial will show you how to connect multiple date fields into common time dimensions, like month and week.

-Rob

http://robwunderlich.com