What happens when you browse in BIDS/SSDT?

It could have something to do with visual totals. Are you browsing as an admin or under a restricted role?

akirajt (11/6/2013)

---

Problem:

How should I enable to do it? I tried using IIF and case statement but it doesn't want to do it due to text value. It only works with...

There are literally dozens of products out there that will do what you need, google is your friend 😀

Sticking "in-house" with microsoft apps, in sharepoint (2010 and up) there is...

Take a look at Marco Russo's brilliant DateTool dimension. It does a similar thing to the Time Intelligence stuff but it's much better and more configurable to whatever your needs...

Having thought about it it's probably not them anyway. You can reach them by double clicking on your datasource in BIDS.

I think you need to look at your SSAS...

Can you have a look at your data source in BIDS and check that the Query Timeout, Connect Timeout and General Timeout are all set to "0"?

Could be a number of things.......

Is the dimension deployed and processed?

Are the permissions you are using have access to the dimension?

Can you navigate to the cube within SSMS?

My last reply was concerning your original problem (displaying incorrect values when more than one brand is selected). It's difficult for me to test anything without having access to your...

I think your issue is with this:

MEMBER [Measures].[FID] AS

Head(

NonEmpty(

EXISTING [Time].[Fiscal Hierarchy].[FiscalMonth].Members,

([Measures].[JBA Sales Quantity])

),

1

).Item(0).properties("key", TYPED)

Since you...

It's "[" code="SQL" "]" your code "[" /code "]"

Without the quotes around the square brackets.

Ok, but once again:

Can you post the full MDX of the report (make sensitive things generic) and please wrap it in a code block.

I suspect it's something to do with...

What MDX are you using to set this measure?

Can you post the full MDX of the report...

Firstly, for the love of all that is holy please format your code and put it in a code block before posting it here 😀

WITH

SET SP AS...

Something like this would work:

[Code="Other"]

WITH MEMBER [C]

AS

SUM(NULL:Axis(1).Item(0).Item(Axis(1).Item(0).Count-1).Hierarchy.CurrentMember, [Measures].[Your Measure])

SELECT

{[Measures].[Your Measure], [c]} ON 0,

[Your Dimension].[Your Hierarchy or Attribute] ON 1

FROM

[Your Cube]

[/code]

Hope that helps 🙂

Hi Robin,

Actually I don't think that is working.

What your result should be is the same figure 3 times. It would if you wrote the query like this:

WITH MEMBER [Measures].[MinValue]...