Need sum of Measure

[Dineshpullagura]

Hello,

I am using cube as my data source. I have four measures and two dimensions in my cube.  I am using a date prompt which prompts user to select a relative date like LTD, last one year, last six months etc.,

In my report i want to show the sum of a measure based on the user selected date. Let's say if user selects last one year from the prompt, i want to show the sum of the measure for the last one year.

I am using a singleton container to display the sum of the measure.   I have created a query which contains the measure data item and a detail filter which filters on the date.

This is how my Fact table looks like

Measure  Dimension1_id Dimension2_id
202              1                  101
203               2                 102
.
.


When i run my report based on the date selected by the user, instead of getting the sum of the measures, i am getting only the first value in the fact table (which is 202).

Please suggest.

Thanks for your time.

[Francis aka khayman]

are you sure you are getting the first value?

most probably you are getting the value as a result of your detail filter.

btw, detail filter is not a good idea in dimensional reporting.

I have created a query which contains the measure data item and a detail filter which filters on the date.

[Dineshpullagura]

Yeah i have checked the query by "view tabular data". And the first value in that output is the what i am getting in the report output.

Yeah it is because of detailed filter, I checked using a slicer and it is giving the sum of the measure.


Thank you.