Linking Targets to Facts

[fescudero]

Hi,

I am struggling to create a good data model to use Set Analysis and calculate the right expressions. Hopefully you can help.

Basically I have the following data model:

Facts Table:

Date

, Business Unit

, Channel

...

, Many other fields

...

Master Calendar:

Date,

...

, standard calendar fields

...

Targets:

Date

, t_Business Unit (identical values to Business Unit in Facts Table)

, t_Channel (identical values to Channel in Facts Table)

, t_Measure_1

And then I try to create some graphs with expressions:

= sum({$<t_BusinessUnit= P(BusinessUnit),t_Channel= P(Channel)>}t_Measure_1)

That works fine, but if I try to use a graph/table with a Channel or Business Unit dimension, the expression is not working as I thought.

Should I change the data model and create an unique Fact Table with the Facts and the Targets?

Now they are linking with the date. Should I create a table in the middle with Business Unit and Channel or link them with the autonumber function instead?

Any suggestion would be much appreciated.

Thanks

[fescudero · Accepted solution]

Hi again,

If instead of having Facts and Targets linked to a Master Calendar as separated tables, I just concatenate them in an unique table (as they share several attributes) then is working fine.

I would like to know, anyways, if there is other way to do it.

Hopefully you have some other ideas.

Thanks a lot.