Report Builder Query

Hi Experts,

I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.

When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.

The problem is report builder allows me to select either Policy count in the report or the amount field.

Have anyone faced this problem.

The same report works in cube browser.

Regards'

Neeraj

Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.

B.

Report Builder Query

Hi Experts,

I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.

When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.

The problem is report builder allows me to select either Policy count in the report or the amount field.

Have anyone faced this problem.

The same report works in cube browser.

Regards'

Neeraj

Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.

B.

Report Builder - Numeric Aggregate Aggravation

So I'm building a report model containing several 8 or so numeric amounts. All amounts are numeric(10,2), and there is nothing that would differentiate the columns other than their names.

One of the columns WILL NOT generate any aggregates. It just appears as an attribute. It's inexplicable.

I've even tried to build a model containing just this one numeric attribute, and it still does not work!! VS just hates this one element! Anyone seen anything like this?

I'm running VS 2005 Sp1.

Ah, the beauties of "automagic" model generation. :)

In this case, model generation thinks it's an "ID" column because it's numeric and it ends in "id", so it doesn't bother to generate aggregates. You'll have to do it manually, or change the name temporarily to fool it.

|||

WHAAAAAAAAAAAAAAATTTTTT?

What genius came up with that! Any why would an ID field be numeric 10,2!!

Thank you thank you thank you!

And how do you do manual specification of aggregates in the model?