Create a PowerPlay report in ReportNet

[dammora]

Hello,

Does anybody have an example of how they developed a PowerPlay report in ReportNet.  I am trying to develop a report with calculations using the same column as a row.  Any examples or ideas?

Thanks

[BIsrik]

i heard u can create powerplay cubes in cognos8. but i couldn't get what u want u trying in the report...

srik

[dammora]

I want to create a crosstab report that currently can be done using a cube.  I want to display fiscal year as a column, currency as a measure and account values as rows.  The problem I am running into is that I want to create calculations at the row level. 

Below are some examples for illustration purposes:

1.  Total accounts = account A + account B + account C
2.  Margin = Total accounts - Gross Sales

I want these calculations to show up as rows in the 'row' section of the report and I want to be able to drag it under a certain group of accounts. Essentially some calculations are built off other calculations and I want them all to be displayed as rows.

I need to replicate a PowerPlay multi-dimensional report using ReportNet.  Does this explanation help?  Any ideas or thoughts are greatly appreciated.  Thanks

[mikegreen]

Hello,

Does anybody have an example of how they developed a PowerPlay report in ReportNet.  I am trying to develop a report with calculations using the same column as a row.  Any examples or ideas?

Thanks

Why is this in the Cognos 8 forum? Are you using Cognos 8 or ReportNet 1.x?

Do you have the Powerplay cube data in a CRN framework?  If yes, then you can make a crosstab report in CRN (in ReportStudio) pretty easily..

With C8, you can use ReportStudio and QueryStudio/Analysis Studio with any datasource - Cubes, framework to database, metrics, etc. 

Regards,

Mike

[dammora]

For some reason my inquiry was moved to COGNOS 8 but I am not on COGNOS 8.

I do have the PowerPlay data in a CRN Framework model, however, I have yet to develop a crosstab report that mimics the Powerplay report based on the specs I listed.  Do you have any examples of reports that represent what I am describing?

Thanks

[dammora]

Also, I am using ReportNet 1.1 MR2

Thanks

[mikegreen]

I dont have any examples I can post.. but It is pretty simple - drag over a crosstab object... Drop in your query items like you would in Powerplay.  You can also drop in calculations.



Regards,

Mike

[dammora]

Hi,

I know how to create a crosstab report, however, the calculations I am trying to create are based off the same field I am dropping into the rows section of the crosstab report.Ã,  The calculations have not been defined in the CRN Framework model.Ã, 

Example of what I am trying to do below:

Fiscal year = 2005 as a column on the crosstab

Currency = measure on crosstab

These accounts are rows on the crosstab

account a
account b
account c
account d

I need to create a calculation that adds up (account a + account c) and create a row called Total Accts.  This is one of the calculations I need to create using the same field.  Any thoughts?

[CoginAustin]

Is this even possible? I ran into this same need and havent figured it out yet..

[JGirl]

Hey guys,

I don't know if there is a better way to do this (since I havent really tried to do this before now), but I do know a workaround.  You can use a union query to add the calculation to the result set.  Probably not the best way if you need to add one hundred calculations, but definitely OK for one.

You create a query that uses a unioned tabular set.  In one of the tabular models, have the query that returns the entire record set to include in the crosstab.  In the other tabular model, apply filters to restrict the data that you want to calculate (ie account in ('a','c')) then dummy the value of the field in the rows to contain your text description.

Of course, the only catch is that to union the data you need to have the same data types in each of the fields you are unioning, so you might have to force your rows column to be a varchar column if it isnt already to be able to include your own label.

Ive created a report like this in the 'Go Sales and Retailers' package (see attached)

J

[dammora]

I tried creating a union query but this approach is difficult when you have many calculations.  Also I haven't found a way of moving them around with the row level.

[RP]

Hi, I'm new to Metric Studio, so any one have any document or anyother links, so that it will help me in my new project...
can you send to rparcha@yahoo.com..

Thanks
RP