Viewing 15 posts - 331 through 345 (of 596 total)
I've replied to the thread in analysis services.
November 25, 2014 at 2:03 am
Don't duplicate posts. This has nothing to do with Reporting Services.
Original post here: http://www.sqlservercentral.com/Forums/Topic1638471-17-1.aspx
November 25, 2014 at 1:24 am
Don't duplicate posts - this has nothing to do with Reporting Services
Original post here: http://www.sqlservercentral.com/Forums/Topic1638472-17-1.aspx
November 25, 2014 at 1:23 am
More information would be good, yeah 😀
What is the size of your cube? How many aggregations do you have? Server architecture? Anything else happening on the box? So, so many...
November 25, 2014 at 1:21 am
You need to process the entire database, not just the workspace one.
November 25, 2014 at 1:14 am
I agree with Alvin - you should do some research on MDX and then write your query (assuming you haven't got a problem with your cube).
As a "shortcut", download...
November 20, 2014 at 5:13 am
You don't need those Unions:
{[Months]
,[Date].[Month of Year].YTDROR
,[Date].[Month of Year].ITDROR
} ON COLUMNS
You didn't explain what you were trying to do?
November 13, 2014 at 7:24 am
Firstly:
http://formatmdx.azurewebsites.net/
🙂
Secondly, can you explain what you are trying to achieve with this query in plain terms?
November 13, 2014 at 6:28 am
Mkrish (11/6/2014)
i wrote below expression but iam getting null valuesMEMBER
[Measures].[YTD] AS
SUM(
PERIODSTODATE
([Date].[Month Name].&[April],[Date].[Month Name].CURRENTMEMBER),[Measures].[Amount])
can u pls rectify this one
so that i can achieve my target
Firstly, is [Month Name] a hierarchy?...
November 6, 2014 at 4:18 am
YSLGuru (10/28/2014)
SELECT{[Accounts Budget].[Default].&[UNITS]} ON 0,
NON EMPTY {DESCENDANTS([Properties].[Default].&[Total], , LEAVES)} ON 1
FROM [Budget Model]
WHERE ([Time].[Default].&[2014M01], [Measures].[Value], [Time Perspective].[Default].&[BASE], [Version].[Default].&[ACT]) CELL PROPERTIES VALUE
It would seem that the measure group where you are...
November 6, 2014 at 3:18 am
I already have done - without knowing your setup I have just given you example code which you can use to apply the same logic to your own cube. Let...
November 6, 2014 at 2:47 am
On the surface, I would say that your issue is that a tabular model is being used where a multidimensional one should be used (10 years of history is potentially...
November 6, 2014 at 2:35 am
The following query against AdventureWorks show two methods to get a YTD figure. Using the actual YTD function means having your date dimension and attributes set up with correct types....
November 5, 2014 at 5:18 am
Have you defined a Drillthrough Action on your cube? If so can you please share the code.
November 5, 2014 at 1:27 am
http://www.sqlservercentral.com/blogs/dknight/2009/11/22/change-the-report-manager-logo/
There's also guidance for changing the name if you scroll down.
October 23, 2014 at 11:54 am
Viewing 15 posts - 331 through 345 (of 596 total)