formulas on OLAP cube

Question

Post reply

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jayne Walley Newbie Points: 1 More actions · Answer 1

I need to create few formulas on OLAP cube

I can create a calulated member like

Median({[2000]},[Measures].[Avg of Time to approval])

How ever I do not want to hard code year 2000, I want into be dynamically

selected when I select the time interval at run time on the pivot table.

If you guys can spend time on this i will make sure will compensate for your

time

Please contact me at ksurya@inventumtech.com or call me 443-983-3133

Good day

Anu

Instead of {[2000]} use {[Time].currentmember}

Edited by - Jayne Walley on 12/03/2003 10:07:38 AM

anuhoney Newbie Points: 2 More actions · Answer 2

Newbie

Points: 2

December 3, 2003 at 1:18 pm

Thanks a lot for the answer.

hoosierpride Mr or Mrs. 500 Points: 565 More actions · Answer 3

Mr or Mrs. 500

Points: 565

December 4, 2003 at 10:08 am

Currentmember will impact every query no matter what level of time you are on. If you need this to always be at the year level use the following:

Ancestor(Time.Currentmember, Year)

Hope that helps.

Steve Hughes

Magenic Technologies