You need to download and add the ASSP assembly to your SSAS instance (instructions here: http://asstoredprocedures.codeplex.com/wikipage?title=Installation%20Instructions&referringTitle=Home) and then use the example provided in the previous link to use the Like...

Create a set of the two members in a crossjoin and then do a sum on it.

So something like

WITH MEMBER [YourCalculation]

AS

SUM

(

{([Country].[Country].&[India] , [State].[State].&[Andhara])}

,

[Amount]

)

Although of course you have provided...

You can achieve this easily by using the Like function in the ASSP project:

http://asstoredprocedures.codeplex.com/wikipage?title=StringFilters&referringTitle=Home

I must admit, I do enjoy Mr Celko's posts and the subsequent reactions :laugh:

Are both of your dimensions related to the fact in your Dimension Usage tab in SSDT/BIDS? How is it not filtering? What is the expected result? What is the result...

Great article Jason.

I think if used in the "correct" way synonyms can be useful as you illustrate here - but I think they need to be documented. Time and...

Without knowing the structure of your hierarchy it's difficult, but at a guess I'd say that your query is doing exactly what you are asking it to - showing descendants...

It's because you are not suppressing the ALL member of the hierarchy. Try using [DimDate].[Hierarchy - Fiscal Day].CHILDREN instead.

It means the task was cancelled.

Ref:

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.wrapper.dtsexecresult.aspx

A few things could be causing this....

Firstly your code:

CASE WHEN [Measures].[R]= 0 THEN 0

This returns a zero rather than a NULL so any NON EMPTY precedents in the queries (these...

Is the parameter defined in your dataset/shared dataset?

Sorry, misread your post. I had this issue once and the problem was with the shared dataset.....

Have you made sure that the names...

In BIDS if you go to New Project, in the analysis services menu you have an option to Import from Server. This will create a BIDS package from your SSAS...

You need to set appropriate attribute relationships and composite keys for your attributes. More here http://www.databasejournal.com/features/mssql/article.php/3792761/Introduction-to-Attribute-Relationships-in-MSSQL-Server-Analysis-Services.htm

I'm going to assume you are using SSRS here....if so you have to be careful when passing parameters from one report to the other using mdx (for a number of...

Firstly, have a read of this article by Chris Webb about the performance of DateDiff: http://cwebbbi.wordpress.com/2014/06/09/calculating-ages-in-mdx/

Secondly,

It doesn't seem like you are doing anything that is particularly dynamic so, depending on...