TR2718 dimension not associated with any measure

[sundarbaba]

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

[Cinu8]

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

[vijayab]

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

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