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.
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.
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?
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