November 26, 2008 at 10:42 am
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
November 26, 2008 at 11:04 am
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
November 26, 2008 at 12:00 pm
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
November 26, 2008 at 12:07 pm
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
November 26, 2008 at 12:17 pm
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
November 26, 2008 at 9:29 pm
http://www.sqlservercentral.com/articles/T-SQL/63681/
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2008 at 11:50 am
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..
November 27, 2008 at 9:43 pm
I've never used MDX queries... that's why I pointed out a traditional cross-tab.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy