I'm not sure of your hierarchy structure but something like this would do the trick:

CREATE MEMBER CURRENTCUBE.[Measures].[TOTAL Inventory Count]

AS SUM( ANCESTOR([Sales Date].[Sales Date].CURRENTMEMBER,

[Sales Date].[Sales Date].[Year]),[Measures].[Inventory Count])

No worries 🙂

But I must apologize, that was needlessly messy and I forgot about using Local Currency as a default.

Have a go with this instead...

CREATE MEMBER CURRENTCUBE.Measures.[Amount] AS [Measures].[Amount...

You could do this with nested Scopes. Like so:

CREATE MEMBER CURRENTCUBE.Measures.[Amount] AS NULL;

SCOPE (Measures.Amount);

SCOPE

(Measures.Amount);

IF [Currency Conversion].[Currency Conversion].currentmember IS [Currency Conversion].[Currency Conversion].[SEK]

THEN

THIS = [Measures].[Amount SEK]

END IF;

END SCOPE;

SCOPE

(Measures.Amount);

...

Sorry, this'll do it:

SELECT NON EMPTY {[Measures].[planned_cumulative],[Measures].[Last Forecast CW] } ON COLUMNS,

NON EMPTY { ([Project].[Projekt-Task].[Task].ALLMEMBERS*{[Date].[DATECW - CW].CurrentMember.Lag(2) : [Date].[DATECW - CW].CurrentMember}) } ON ROWS

FROM [DWH]

You can use an Execute Process task in your control flow to call a command line zip utility. I am assuming this is what you are having issues with since...

You're getting an error because you are using a member rather than a set in your crossjoin.

Try this:

SELECT NON EMPTY {[Measures].[planned_cumulative],[Measures].[Last Forecast CW] } ON COLUMNS,

NON EMPTY { ([Project].[Projekt-Task].[Task].ALLMEMBERS*{[Date].[DATECW...

You can just use something like IIF((your calc) = 0, NULL, (your calc)) / IIF((your calc2) = 0, NULL, (your calc2)) to stop the error.

Change the NULLs to 1...

I'm thinking "Grand Total" isn't part of the dimension you are using on Axis 0 but rather something that's generated by the VS browser. So if "Grand Total" isn't a...

You don't really go into too much detail like..... Were you able to start the service again? What version are you running? What sort of disk setup do you have?...

http://msdn.microsoft.com/en-us/library/ms145514.aspx

http://technet.microsoft.com/en-us/library/aa216769%28v=sql.80%29.aspx

🙂

Something along the lines of

WITH MEMBER

[Cumulative Total] AS SUM({NULL:[Date].[Quarter].CURRENTMEMBER}, [Your Measure])

would do it, obviously change it to suit your environment 🙂

Sorry I misread the post, the above may give you...

Have you considered having one cube and just using role based security on dimensions?

http://msdn.microsoft.com/en-us/library/bb500251.aspx

Firstly I would make day of week an attribute of your date dimension and put it in a hierarchy. Then you could use the AVG function to achieve what you...

If you have no date columns then how can you tell if a group of sales all occurred in one year? It doesn't make much sense to me.

In any case...

Once you have deployed an SSRS report you can edit the subscriptions and get it to be emailed to whoever you like at whatever time you like.

See the following:...