*LENGTH: 2 Months +*
*LOCATION: MEMPHIS, TN*
*Our need is for the design and modeling of an IBM Cognos Transformer cube
plus 9 reports based on that cube.*
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
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 post to this group, send email to email@example.com.
Visit this group at http://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.