Dynamic caolumn Calculations

Question

Dynamic caolumn Calculations

lrams99

Valued Member

Points: 59
More actions
November 26, 2008 at 10:42 am

#383472

Hi All
I need a calculation on dynamic columns, like In layout its one , prodcut, column(measure), when i went to preview there are the prodcut, 5 measure columns.
How to do the calculation on col 4 and col 5 of measure values...
Thanks in Advance
SR

Viewing 8 posts - 1 through 7 (of 7 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Could you please explain a bit more what you're trying to do? I don't understand the question.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

lrams99 Valued Member Points: 59 More actions · Answer 2

Hi

Matrix layout my report: year / ### calculated field

prodcut sales rev

preview: Year (2008) calculated filed

q1 q2 q3 q4 ###

jackets 12 14 13 15 ### (q4-q3)

Like this is my report ...here i need is when i select year and no.of qtr (parameter) then

i need to calculte last two qtr's difference, whatever the last and last but quarters...

Thanks 3 ur reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

What does the query for the report look like? Can you do the calculation there?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

lrams99 Valued Member Points: 59 More actions · Answer 4

My SSRS report on OLAP cube...

how can we calculate the last 2 qtrs fiffrence dynamically, wheather in OLAP cube / Data tab or somewhere else..pls let me know

Thanks

Gail

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

http://www.sqlservercentral.com/articles/T-SQL/63681/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

lrams99 Valued Member Points: 59 More actions · Answer 6

Hi Jeff

I got your point..here is my MDX query

select

[Measures].[Total Days Cash on Hand] ON ROWS,

LastPeriods

(5,[Time].[Fiscal].[Fiscal Year].&[2009].&[2]) ON COLUMNS

FROM

MyCube

bu using this i got the result for last five quarters..then i need to create a calculated memeber on the values of last 5th and 4th qtrs...how to do this..

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

I've never used MDX queries... that's why I pointed out a traditional cross-tab.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)