master calendar loading

[#1]

hi,

I have got a loading issue, I don't have any idea to load my data.

I need to have a calendar to select a date and 2 pivot tables based on 2 differents dates (date1 and date2).

If I select the 26/02/2012. Il would like to see

-in the first graph every data for date1 = 26/02/2012

-in the secondgraph every data for date2 = 26/02/2012.

Have you got any idea?

Thanks a lot

[Jason_Michaelides]

Fact:

LOAD
     ID

     ,Date

     ,Amount

     ,'Invoice'     AS     Fact_type

FROM...Invoices...;

CONCATENATE (Fact)

LOAD
     ID

     ,Date

     ,Amount

     ,'Purchase'     AS     Fact_type

FROM...Purchases...;

Then, in your charts you can have a dimension of Date and Expressions:

SUM({<Fact_type={Invoices}>} Amount) for Invoices and

SUM({<Fact_type={Purchases}>} Amount) for Purchases

Hope this helps,

Jason

[#3]

Thanks, but in fact, it's the same fact. :S Do I need to duplicate all data

[Jason_Michaelides]

What do you mean, "it's the same fact"?

[#5]

My fact have got 2 dates. In 1 graph I display by the fisrt date and in the other, I display by the second date

[Jason_Michaelides]

Can you post a sample of your source data?

[#7]

Hi,

Please, find an example attached.

I really need to link it to others tables, I cannot leave it isolated.

Eva

[Jason_Michaelides]

I'm sorry Eva but I really don't understand what you're trying to do!

What are Date1 and Date2 in your inline table?

[#9]

Sorry about that!! I will try to explain better.

when I pickup the date 01/01/2012 in my list.

I would like display :

-for the first graph

Dimension  Date1. Value 20

-for the second graph

Dimension  Date2. Value 10.

My set of data is different in both graphs.

I did it like that :

-disconnect my master calendar and data.

-make dimension with : if(master_calendar_date = date1, date1).

the behavior is ok, but performance are really bad.

[mphekin12]

Eva,

Why do you try to split you fact table into two tables.  One table for Invoices and on for Purchases then have each of these tables link to your Master Calendar.