Topic
• Latest Post - ‏2014-02-09T21:00:07Z by TimTam18
4 Posts

# Pinned topic Calculation across queries in Cube Reports

‏2014-02-07T11:07:31Z |

Hi All,

I have transformer cube published as a data source and a package on which I am creating a report in Report Studio. I have used two queries "query1" and "query2". In "query1", I have used two dimension "dim1" and "dim2" in rows and one metric "met1" in column. In "query"2", I have used three dimension "dim1", "dim2", "dim3" and a metric "met2". Now, my requirement is two created a third metric which will be equal to "met2"/"met1"*100. I can not use this in a single formual since "met1" is not calculated on "dim3" and hence returns blank cells. Can anyone please help me out how can I achieve this? Both query1 and query2 are used in there corresponding crosstabs.

Thanks You.

• TimTam18
11 Posts

#### Re: Calculation across queries in Cube Reports

‏2014-02-09T21:00:07Z

Hi,

If the package has one single cube and all the dimensions/levels are in scope of the measures involved, then you should not have any problems. The problem here, I think, is your statement that ""met1" is not calculated on "dim3"" - does it mean that dim3 is not in scope of met1? This can be checked using the instructions here:

If it is the case then theoretically you can not calculate "met2"/"met1"*100 and put it in the same list/crosstab as dim3 because they're not in scope.

Hope this helps,

TT

• TimTam18
11 Posts

#### Re: Calculation across queries in Cube Reports

‏2014-02-09T21:00:07Z

Hi,

If the package has one single cube and all the dimensions/levels are in scope of the measures involved, then you should not have any problems. The problem here, I think, is your statement that ""met1" is not calculated on "dim3"" - does it mean that dim3 is not in scope of met1? This can be checked using the instructions here:

If it is the case then theoretically you can not calculate "met2"/"met1"*100 and put it in the same list/crosstab as dim3 because they're not in scope.

Hope this helps,

TT