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
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
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
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
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
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