So you want the sum of the data for a select number of months without months appearing in the query?

Try one of three types of MDX to do this

Select [product]...

Can't you search the entire network?

Also is what you are adding is set up as a group not a user. By default SSAS won't detect it unless you...

Can you give an example?

I don't really understand how you'd need to group in MDX as it is implicitly done

Mack

John - I think he wants the package to run each time data is added/updated to a table

I think, as Phil has suggested, that replication might be his best option

Sorry - ignore my post I misread what you had written

Try this tutorial

http://msdn.microsoft.com/en-us/library/ms365330(v=sql.105).aspx

Mack

Try something along the lines of

with

set [Product List] As

NONEMPTY(

{[Product].[Product Level 4].[All].Children}

, ([Measures].[Revenue],[Date].[Day].&[20121212])

)

-

NONEMPTY(

{[Product].[Product Level 4].[All].Children}

, ([Measures].[Revenue],[Date].[Day].&[20121201])

)

select [Product List] on rows,

{[Date].[Day].&[20121201],[Date].[Day].&[20121212]} on columns

from [Your Cube]

where ([Measures].[Revenue])

Mack

Sounds to me like you are processing a cube and have fact records that have no corresponding dimension data (for example you have a sales record for a client that...

Sounds a bit wierd...

Anyway, in your employee dim view create two columns - one that is Surname, FirstName & one that is FirstName Surname

Add these to your employee dimension (don't...

You need to provide the Tail function with a set - you have provided the current member which is just one value ie a set with one value

So Tail(CurrentMember,3) =...

Not sure I really follow you issue.

Do you have MDX you can share - it might make your issue easier to visualise?

Mack

Ahhh - this is in the cube structure screen (the main cube bit)

There should be a pane with measures & one with dimensions. Expand the dimension in the dimension...

Hi,

You can edit this in the dimension pane within the cube editor (the window that shows you what dims you have in you cube & allows you to add more)....

I have but I found the best way of doing this was to us a script component in the data flow The issue I found with having MDX in...

Not sure how much guidance you need here but you can use 64-bit SSIS to use 34-bit drivers as you can run it in 32-bit mode

To create 32-bit drivers on...