If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to get Maximum value from time dimension

Started by lav4you, 06 Jan 2010 04:56:51 AM

Previous topic - Next topic

lav4you

I have a cube where i want to use the maximum value from for timescale dimension.

following is the example for ur refernce

exmaple: 1
           Apr   May   Jun   Jul   Aug   Sep   Oct   Nov   Dec   Jan   Feb
Value           10   20   30   40   50   30   40   60   10   25   40
TimeMax   60   60   60   60   60   60   60   60   60   60   60

example 2
                Apr   May   Jun   Jul   Aug   Sep   Oct   Nov   Dec   Jan   Feb
Value           10   20   30   40   50   30   100   100   10   25   40
TimeMax   100   100   100   100   100   100   100   100   100   100   100
can anyone suggest the most efficient way of implementing this calculation






StuartS

Hello

Are you referring to the length of the time dimension set in the D-Link options?  If so then there are a number of Bif functions you can consider.  e.g. @Time

If it is not this then please give more information.  Is it values in a D-Cube?

Regards

Stuart

lav4you

sorry for my late reply

No here im refering to a calculation in a cube
i want to derive the best case from the month or the highest value from month

as i mentioned above
60 and 100 are the highest value

StuartS

Hello

I believe I understand what you are trying to do.  Unfortunately I can think of no way of modelling in analyst the way you want to achieve.

If you had several items in a month and wanted to find the maximum you could use TMax Bif.  But I dont think thats what you want from your diagram.

The only way to apply a value across all time periods as in your diagram would be using an internal D-link.  How to calculate the maximum with which to feed this D-Link, I am unsure.

Sorry

Stuart


vipul.bahl@gmail.com

Hi,
There is a work around for it. I have tested it and its working fine.

In your dlist-1 (let's say) (having items Value and Time max) add all the months by coping it from the months dimension.
Then create an Internal D-link to transfer the data entered against value in the Dlist -1 (for all months) so that all the rows in the Dlist -1 are populated.
After that Use bif TMax to select the maximum from each row (select only months) and it will give you the desired result.
After that you may hide all the un-necessary rows using access tables.


It will look some thing like this.

   Jan   Feb   Mar   Apr   May   Jun   July   Aug   Sep   Oct   Nov   Dec
Value   10   20   30   40   50   30   40   60   10   25   40   15
Jan   10   10   10   10   10   10   10   10   10   10   10   10
Feb   20   20   20   20   20   20   20   20   20   20   20   20
Mar   30   30   30   30   30   30   30   30   30   30   30   30
Apr   40   40   40   40   40   40   40   40   40   40   40   40
May   50   50   50   50   50   50   50   50   50   50   50   50
Jun   30   30   30   30   30   30   30   30   30   30   30   30
July   40   40   40   40   40   40   40   40   40   40   40   40
Aug   60   60   60   60   60   60   60   60   60   60   60   60
Sep   10   10   10   10   10   10   10   10   10   10   10   10
Oct   25   25   25   25   25   25   25   25   25   25   25   25
Nov   40   40   40   40   40   40   40   40   40   40   40   40
Dec   15   15   15   15   15   15   15   15   15   15   15   15
Tmax   60   60   60   60   60   60   60   60   60   60   60   60


lav4you

Hi All,

thank you for your valuable inputs... and very sorry for such a late reply

just wanted to share the info that I have achieved that just by declaring calculation dimension as  dummy timescale dimension instead of the months dimension ....it works gr8