Analytics Software

This has caused a few days frustration.

I am a novice to the OBIEE world, with about 6 months of hands on experience with 2 days in a course of "Oracle BI presenatation services 10G: Create Reports/Dashboards Ed 1." I do not do any of the hard coding and/or backend. I am pretty much purely within "Answers" for my job.

What I want: (The formulas are variables that have been developed to run those formulas by someone on the backend)

Acct lvl 1 - - - - - - - - - - Acct lvl 2
AA - - - - - - - - - - - - - - - W
AA - - - - - - - - - - - - - - - X
BB - - - - - - - - - - - - - - - Y
BB - - - - - - - - - - - - - - - Z
(Formula AA - BB) - - - - (Formula AA - BB)
(Formula AA-BB / AA) - - (Formula AA-BB / AA)
CC - - - - - - - - - - - - - - - S
CC - - - - - - - - - - - - - - - T
DD - - - - - - - - - - - - - - - U
DD - - - - - - - - - - - - - - - V

What I am getting

AA - S (null)
AA - T (null)
AA - U (null)
AA - V (null)
AA - W
AA - X
AA - Y (null)
AA - Z (null)
BB - S (null)
BB - T (null)
BB - U (null)
BB - V (null)
BB - W (null)
BB - X (null)
BB - Y
BB - Z
(Formula AA - BB) - S (null)
(Formula AA - BB) - T (null)
(Formula AA - BB) - U (null)
(Formula AA - BB) - V (null)
(Formula AA - BB) - W (null)
(Formula AA - BB) - X (null)
(Formula AA - BB) - Y (null)
(Formula AA - BB) - Z (null)
(Formula AA-BB / AA) - S (null)
(Formula AA-BB / AA) - T (null)
(Formula AA-BB / AA) - U (null)
(Formula AA-BB / AA) - V (null)
(Formula AA-BB / AA) - W (null)
(Formula AA-BB / AA) - X (null)
(Formula AA-BB / AA) - Y (null)
(Formula AA-BB / AA) - Z (null)
CC - S
CC - T
CC - U (null)
CC - V (null)
CC - W (null)
CC - X (null)
CC - Y (null)
CC - Z (null)
DD - S (null)
DD - T (null)
DD - U
DD - V
DD - W (null)
DD - X (null)
DD - Y (null)
DD - Z (null)

The pivot table showing these results works with the Acct 1 level by itself. Expanding it into Acct 2 is where we are stuck. The table looks like

Columns:
current month

Rows:
Measure Lables
Acct - lvl 2

Measures:
AA
BB
(Formula AA - BB)
(Formula AA-BB / AA)
CC
DD

What other information is needed that may help to answer this question?

Any feedback is greatly appreciated.*

In our old system, Cognos, "Zero Suppression" seemed to be the solution. There seems to be no equvilant in OBIEE.

Edited by: user10269236 on Sep 16, 2008 9:32 AM

Edited by: user10269236 on Sep 16, 2008 11:50 AM