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

measure value not showing in Analysis studio

Started by kchandan, 16 Feb 2012 11:19:32 PM

Previous topic - Next topic

kchandan

Hi All,
I have a query item named number_of_opportunities. I have made it as a measure dimension in framework manager.On testing it it gives a value 280(total no of opportunities).
But  in Analysis studio when I try to make a report taking geography and practises as row and column ,the value of no_of_opportunities(measure) is not spliting i.e it is showing 280 for all rows and columns.

I am new to framework manager.please help.

blom0344

You may need to read up on 'scope relationships' . By setting the scope you can ascertain that measures are correctly rolled-up/distributed against dimensions.
When you switch to 'dimension map' you will have the correct GUI to change/define them.

kchandan

Than you for your suggestion,but I have set its scope.
Is it mandatory that for making a measure dimension,the query item should be from fact table?

blom0344

Not mandatory, but if you want to perform counts it is often better to define the measure as a fixed value '1' and use sum as aggregate setting. This way you can define a measure if no fact subject is involved.

You do not mention how you have defined no_of_properties, so it is a little hard to advice in more detail