Can't seem to edit my last post, so apologies for the double email you may get.

Tried in Reporting Services (2008) and couldn't get it to order correctly, despite all manner...

Hi Sebastian,

I'm not sure of the reason for that. I set up a test to have a go.

When I query the cube with mdx from management studio it displays from...

Hi,

Drag your Monthname and Fiscal Month No to the Attributes pane for your dimension.

Create a hierarchy of English Month Name, and Fiscal Month No underneath.

Right Click English Month Name...

Bit difficult without logs, but sounds like permissions?

Is the connection for SQL Server using windows authentication?

Are you executing the package client side with the same privileges as when you...

Unless i'm misunderstanding the question, if the user is only granted select to certain tables (under securables), then in their object browser they will only see those tables available, in...

May depend upon a lot of factors, but could look at using Analysis Services instead?

ETL -> Datastore -> Cube

Then query the cube using MDX through Reporting Services. I won't...

Hi,

If the smaller field is indexed it would be a lot smaller than on the full address.

If there's a postcode field then all that may be required to establish a...