Cognos8 and Dimensional Data Reporting for Percentage formulas

[krrogovin]

Hi,

I am trying to create a percentage formula in a Cognos8 Reportnet crosstab report using dimensional data. The reports looks as follows:

Time (All members--so this is dynamic)
Product(decendants) Qty %ofTotal

2006
Product A 100 10%
Product B 900 90%


In the past, the formula simply read:

percentage(measure)

However, since the cube is now the data source, this generates a hierarchy error. I have tried using the formula from the Cognos8 manual:

percentage(numeric exp [tuple member_expr {,member_expr}] within set set_expr[, set_expr})

Regardless of what level of the different hierarchies I use (and various combinations), I can't seem to generate what should be a very simple formula.

Any help would be greatly appreciated.

thank you!

 

[JGirl]

Im guessing your query already includes the following columns:
* "Qty" (The measure - ie. 900, 100)
* "Product" (The rows - ie. Product A, Product B)

Create a new query item called "Percent of Qty", and define it as
percentage([Qty] within set [Product])

J

 

[krrogovin]

Hi JGirl,

Unfortunately, this didn't work either. I received the following error:

Unable to support query items from the same dimension on different report dimensions 'edge=axis(0); dimension=[MEASURES]''edge=axis(2); dimension=[MEASURES]'.

I think I have to show the intersection between the time and the product, which is done through "tuple" (I think) but I can't seem to get past the hierarchy and dimension errors.

thanks!