If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

TR2718 Dims not associated with any measure

Started by cognos_dev, 23 Oct 2007 10:15:46 AM

Previous topic - Next topic

cognos_dev

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

COGNOiSe administrator

The lowest level of each dimension in your case, needs to be a filed that goues by the same source name in your dimensional and fact query. That's the only way Transformer "joins" or actually glues them together.

PS. Doesn't have to be the lowest, just the most common.

cognos_dev

Hello,
In that scenario, If I have an Indicator like Prod_Sufficient (Y/N), then how do I add that dimension to my cube without having a Prod_SK at the last level. Or How do I handle this situation of adding a dimension indicator to a multiple data source cube model.


rockytopmark

I'm not sure I understand your question, but...

Is Prod_Sufficient part of the list of attributes that belong to Products, for which Prod_SK is the unique key?  If so, then it would be either a Parent of Prod_SK.

It could be a stand-alone dimension in the Model, but only if it has scope to the Fact data sources.  For this you would probably have to add the indicator to the Fact datasource's underlying query, via a join to the Product table.

cognos_dev

Thanks for your suggestion. Even I have done the same here by bringing the indicator field into the fact by having a join between fact and dim in my query subject (in FM) and it works. So in these scenarios where a stand alone dim attribute from a dimension(like the indicators), if needed to be brought into a cube, then it needs to be brought into the fact Query Subj.



consultantcareer

hello,

As transformer creates joins with common column name can it create union as well.

I have two data sources from sql server and oracle with those I need to create union.
IQDs doesn't support multiple data sources..
so if I create two iqds from both these data sources with all column names same(data is totally diff)...will it create union and feed it to cube.....

also is there any way to specify order of execution of sources....

Thanks in Advance,