*LENGTH: 2 Months +*


*Our need is for the design and modeling of an IBM Cognos Transformer cube
plus 9 reports based on that cube.*

*Required Skills:*

*Transformer Q*

*Multi-Dimensional Reporting*

*Job Information:*

1.       Relational *database* on *Oracle*

2.       FM package and Report Studio reports are already in production

3.       This will replace the existing reports (9 total, but only 4 main
reports; others are variation of these 4)

4.       #1 driver is report performance improvement

5.       #2 driver is drill-down capability

Other pertinent facts:

1.       Data is snowflake

2.       1 fact table

3.       10-12 dimensions

4.       19 measures

5.       Most measures are already calculated in db

6.       Real data will be available

7.       *Data architect* and Report *Developer* are available for questions

8.       Rolling 5 Quarters plus two full years

9.       Cannot use Transformer’s rollup of 4 quarters for a year. The Year
is annualized data (pre-calculated in db)

10.   Granularity = 1 record/customer/account/time period

11.   *SQL* tools plus *Cognos* QueryStudio/ReportStudio available

12.   No *security* in model or reports today

Sai Bharadwaj Ch

Unique Key Resources
Phone: 901-405-4858
Email: s...@ukrinc.com
Web: www.uniquekeyresources.com

You received this message because you are subscribed to the Google Groups "SAP 
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.

Reply via email to