Multiple Facts

[imrasyed]

Hi Experts,

I have sales and  Inventory tables.

I have concatenated both the fact tables and It is perfectly fine but the only thing is when i link Customer Dim table to fact table then I am getting Measure(Inventory)  whcih shd be zero.

.

Can you help me out how I can proceed in resolving this Issue?

[mdmukramali]

Hi,

we need to have some more details about your Data Model.

so can you attached sample file with your existing Data Model

Thanks,

Mukram

[Chanty4u · Accepted solution]

concatenate two tables

but  add flags in both the tables to get correct result in front end

Tab1:

load

A,

B ,

0 as Flag

from sql  ;

Tab2:

load

A,

B .,

c,

d,

1 as flag

from sql  ;

frontend:

=sum({<Flag={0}>}Inventory)

=sum({<Flag={1}>}Profit)

[imrasyed]

I did that but My question is how to connect Customer Table to only sales fact table and not with the Inventory.

I just removed the Null values were creating the problem.

Thanks for your help.