topic Custom Item calculation changes in SAS Web Report Studio

Custom Item calculation changes

JohnT — Wed, 08 Feb 2012 23:17:35 GMT

Gday,

I have an OLAP cube setup, and I want to see a ratio (many of them actually) in the report. So, I have not calculated this in the data because the percentage will obviously change depending on what dimensions are being shown/what filters are in place.

So to get these ratios I've created some Custom Items.

I select create the expression using the measures which are available on the left, this is the expression that is created (I think these are the Caption values in Cube Designer):

[Sum Of Gnic] / [Sum Of Gep]

However, later when I want to select new data, for example, it tells me that the calculations are wrong. When I look at the expression I see something new (I think these are the Measure Name's in Cube Designer):

Member::[MEASURES].[GNICSUM] / Member::[MEASURES].[GEPSUM]

Now, I didn't put that in, however, it's what I see when I build/rebuild the cube.

In order to add a new measure or dimension, I need to update all my calculations (I have at ten ratios right now). I don't want to have to update all these everytime I need to added a new item.

How can I get the calculations to either remember what I originally put in or how can I get the report to accept the expression that it's changed to?

We are on the following:

SAS Web Report Studio 4.3

Build Number: 20111010164613939938256(f0wrs43) Build Date: 10/10/2011 Hotfix D26005

Thanks.

Custom Item calculation changes

NN — Fri, 10 Feb 2012 19:20:54 GMT

In order to add a new measure or dimension, I need to update all my calculations (I have at ten ratios right now). I don't want to have to update all these everytime I need to added a new item.

Hi,

Just a question are u defining the calculated member in the cube.. or web report..

Re: Custom Item calculation changes

JohnT — Mon, 13 Feb 2012 00:44:51 GMT

Hi NN,

What I was describing was on the web report.

I've tried both, I don't think doing it in the cube works.

Edit:

It might have worked in a cube, I don't know, but ended up trying to put the calculations in Information Maps, and it works in that (though I didn't think it would). This solution kind of works better for me, because the labels show up without changer to proper case.

Custom Item calculation changes

NN — Tue, 14 Feb 2012 18:44:55 GMT

Hi,

The reason why i had asked was because i too was facing the same type of problem. The only differece being that i was defining my calclated member in the cube.

So i too had ended up using infomap for my calculations.

...