Hi All,
This is for multiple data source model.
I have created the IQD files from C8 FM model. I have seperate
IQDs for each major dimension like product dim, resource dim,
region dim and 1 fact iqd - sales fact. I have brought only 1
dim and 1 fact into my transformner model namely product dim and
sales fact. the common name between these 2 IQDs is Prod_SK.
When I pull in some dimensions like prod_category as seperate
dim (as only level in dim) , prod_group as seperate dim (as only
level in dim). When I created the model, its showing up the
categories in the diagram. but when I build this cube, it shows
up with warning TR2718 for these 2 dims which I have added
saying measures not associated with any dim. But there is only
one column common between these 2 IQDs - Prod_SK (followed same
naming). When I click Show scope for any measure, its coming up
as "Green". How do I really make it work.
Please help
Regards,
S
hi
every one
how do i create a summary totals on report header as we do in impromptu
i am not able to do in report studio
can any body answer this
thank u
cinu
Hi
This error comes because ur fact table has to be linked with the other two iqd's by the common column name.
e.g.
iqd1 conatins columns as
a b c
iqd2 contains columns as
a d e
idq3 contains columns as
a g k
because in Transformer we join the tables by givving a common column name!!
Hope it will help u!! :)
thanks,
vj
Quote from: sundarbaba on 23 Oct 2007 10:12:33 AM
Hi All,
This is for multiple data source model.
I have created the IQD files from C8 FM model. I have seperate
IQDs for each major dimension like product dim, resource dim,
region dim and 1 fact iqd - sales fact. I have brought only 1
dim and 1 fact into my transformner model namely product dim and
sales fact. the common name between these 2 IQDs is Prod_SK.
When I pull in some dimensions like prod_category as seperate
dim (as
only level in dim) , prod_group as seperate dim (as only
level in dim). When I created the model, its showing up the
categories in the diagram. but when I build this cube, it shows
up with warning TR2718 for these 2 dims which I have added
saying measures not associated with any dim. But there is only
one column common between these 2 IQDs - Prod_SK (followed same
naming). When I click Show scope for any measure, its coming up
as "Green". How do I really make it work.
Please help
Regards,
S