Dynamic Requirement

building reports desktopintelligence
1

Hi All,

I have a requirement like this,

Right now there is a small block (kind of table) in the report (Not real table but made up of cells ) Please see the attached screen shot for better view which Looks like below,

     Average

Tier1 10.4
Tier2 7.5
Tier3 5.3

The average is a report level variable calcuated with measure and dimensions.
The Tier1,2 and 3 are direcly from the universe and part of the Average report level variable. (Tier column is in the database table, say table1)

What I would like to have is,

As the Tier column grows my block should grow with Tier4 along with the Average.
What would be the solution for this in the report level? Is it possible in the report level?

Thanks…
Tier.JPG

JohnJustus :us: (BOB member since 2007-06-25)

2

Can it be designed as a cross tab? If not, what prevents it as a cross tab would work as described.

digpen :us: (BOB member since 2002-08-15)

3

I doubt crosstab work.
The average are report level variables. The future object name of the Tier is not fixed ,the name may be different. Also, how can I embed the future Tier names in the formulas.

Say, one of my average formula for an existing Tier is as below,

=Average( If <PrevyearFlag>="Y" Then <Trading Name Current Rank> Where (<PSL NA Core> ="Tier1"))

I believe there should be Pre-calucalted table in the database with columns as PSL NA Core and averages precalculated in another column to achieve this dynamic requirement. Please correct me if I am wrong.

Thanks…

JohnJustus :us: (BOB member since 2007-06-25)