1

I am building a reporting solution using Powerview on Sharepoint Server 2013 with ssas multidimensional data source.

On the powerview reports I have encountered a strange problem. When I filter using a date attribute with multiple values only the non calculated facts (simple measures, not mdx) are being filtered, while for single date selection everything is filtered correctly.

The strange thing is that in the cube browser everything works fine for all facts and all dates selections.

Any idea would be highly appreciated.

Thanks!

Sample Calculations :

CREATE MEMBER CURRENTCUBE.Measures.NewRequestsCount
as

aggregate({[DM RMS Workflow Actions].[Standard Action FK].&[13],[DM RMS Workflow Actions].[Standard Action FK].&[1]},[Measures].[FC RMS Request Actions Count]),
ASSOCIATED_MEASURE_GROUP='FC RMS Request Actions',format_string="#,##0";

and

CREATE MEMBER CURRENTCUBE.Measures.ForwardsCount
as

aggregate(([DM RMS Workflow Actions].[SN].&[62],[DM RMS Is Fake].[Value].&[Real]),[Measures].[FC RMS Request Actions Count]),
ASSOCIATED_MEASURE_GROUP='FC RMS Request Actions',format_string="#,##0";
Andreas Dest
  • 59
  • 7
  • Can you include a sample calc which isn't working? – GregGalloway Nov 21 '15 at 03:12
  • Yes of course, thanks – Andreas Dest Nov 23 '15 at 07:52
  • I just noticed that the behavior is the same for every filter not only the date filters. If I choose multiple values then the calculation is shown for all values. – Andreas Dest Nov 23 '15 at 08:02
  • What is the calculation behind [Measures].[FC RMS Request Actions Count]? Or if it's a physical measure what's the AggregateFunction? If you change Aggregate() to Sum() do you have the same problem? – GregGalloway Nov 23 '15 at 13:04
  • It is the default count of the measure group. Nothing changes if I use sum. The filters work fine in excel pivot tables also...It must be a Power View related problem – Andreas Dest Nov 23 '15 at 13:56
  • If you comment out the entire MDX script except for the CALCULATE statement and use a physical measure in your report does the multiselect work? I'm wondering if your MDX Script has a scope statement that's causing problems. – GregGalloway Nov 23 '15 at 21:09
  • Yes the multiselect works. I have encountered problems in the scope on the past but they were happening both in Power View and Cube Browser. Now the problem happens only in Power View :/ – Andreas Dest Nov 24 '15 at 08:38
  • So what's the problem SCOPE statement? – GregGalloway Nov 24 '15 at 08:39
  • It was in a different project than the current in which I am having the problem. Sorry for the misunderstanding – Andreas Dest Nov 24 '15 at 08:55
  • So you are saying that a physical measure works for multiselect but any calculated measure does not work? Even if the calculated measure is Measure*2 or something simple? – GregGalloway Nov 24 '15 at 19:58
  • Yes exactly! Even for the simplest calculated measure...(tested with measure-1) – Andreas Dest Nov 25 '15 at 10:03

1 Answers1

1

Finally I found a solution.

The problem was solved by installing Sql Server 2012 sp3

https://www.microsoft.com/en-us/download/details.aspx?id=49996.

Andreas Dest
  • 59
  • 7