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

Dimension nor related to measure dimension

Started by Seveman, 26 Oct 2017 03:51:19 AM

Previous topic - Next topic

Seveman

Hi,

I have this model already in place that I need to fix and came across a problem. I have a fact table with several codes that ID dimensions such as customer_id, sales_region_id, policy_number, etc.
There are regular dimensions for each corresponding concept and their tables are correctly related. So there is a customer table, region table, policy table and they all are in a star schema relationship with the fact table 1-n.
There is a namespace in the logical layer of the model and within that namespace there is a metric space. The facts are in the metric space.
The issue is that there is another namespace in the dimesional view and a measure dimension that holds 2 metrics in there and in the content explorer I do not see the policy dimension related to the metrics, so the calculations are wrong and I do not see wher I can add that relationship. Any ideas?
Thanks in advance

--------------

Disregard. I found where to add scope in FM for the measure dimension. I did in the dimension map selecting the measure dimension and the right click on the dimension at the lowest level and "set scope"