COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: gouravatalkar on 23 Sep 2010 01:34:41 AM

Title: Financial Reporting On Transformer
Post by: gouravatalkar on 23 Sep 2010 01:34:41 AM
Hi guys i want to know how do we do financial reporting in powerplay like i want to prepare a cube where we have the hierarchy as Account dimension --> Assets ,Liabilities,expanse etc for different time period.

how does i prepare cube for financial reporting in transformer. i do have business queries for the financial report but confuse how to prepare it. please help me.
Title: Re: Financial Reporting On Transformer
Post by: cognostechie on 23 Sep 2010 03:41:44 PM
You can create a dimension with different levels for accounts.

Ex: Assets and Liabilities both can be level 1. Different Assets can be Level 2 and so on.

Create a Time Dimension based on the date field in your GL Chart of Accounts (Ex: GL Date).

Measures can be Revenue, Expenses etc.

That should do it.