Stack Overflow
Stack Overflow

Questions tagged [ssas-2012]

Microsoft SQL Server 2012 Reporting and Analysis Services is a business intelligence (BI) suite

Allows users to build high performance analytical models (multidimensional and tabular) that can be used for interactive data analysis, reporting, and visualization.

Microsoft SSAS 2012 home page

182 questions
11
votes
1 answer

Process update is taking longer than Process full

I have a cube which has few big dimensions. It is currently taking 2 hours to Process Full. I have now partitioned the cube and followed below strategy: Process Update dimensions Process data Partition (only needed partition) Process index…
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
6
votes
2 answers

SSAS - Cube Browser - SQL Server 2012 RTM

Just playing around with SQL Server 2012 and tried to browse cube; cannot see option of Drop Row Fields here / Drop column Fields here or Drop Filter Fields here. Is this bug or is there any other setting to change the view.
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
5
votes
1 answer

IIF() function not working properly while using multiple times in single MDX query

I need to get the aggregated values based on two conditions using single MDX query Am having below data I have created two calculated functions using IIF() function in a below query WITH MEMBER [Measures].[Expression1] AS…
TAMILARASAN R
  • 225
  • 1
  • 6
5
votes
2 answers

SSAS dealing with non linked data

I'm trying to compare forecast data with sales data in a cube. Sometimes we have a forecast with no actual sale, sometimes we have a sale with no forecast. How do just show 0% if one or the other does not exist? This is my current code... Green…
jhowe
  • 10,198
  • 19
  • 48
  • 66
5
votes
1 answer

SSAS - relationship/granularity

I have 2 fact tables with a measure group each, Production and Production Orders. Production has production information at a lower granularity (at the component level) productionorders has information at a higher level (order level with header…
jhowe
  • 10,198
  • 19
  • 48
  • 66
4
votes
0 answers

Type mismatch error occurs while casting string values to date type in MDX query with some blank rows

I have a string-type dimension in my SSAS cube having the date values along with some blank values and please find the screenshot for your reference. I am trying to convert these values into Date using the CDate function in the MDX query. I have…
TAMILARASAN R
  • 225
  • 1
  • 6
4
votes
1 answer

How to sort records in MDX query when numeric expression is used with TopCount function

I am trying to sort the Top 201 records in my SSAS cube either ascending or descending based on requirements in my C# code. Here I a using Adventure Works Database, where [Reseller Order Count] is the measure and [Reseller].[Business Type] is the…
Sathish G
  • 91
  • 3
4
votes
1 answer

Masking Dimension attribute / Security in SSAS

We have a cube where we implemented the dimension data level security based on ROLE. This security is working fine where we are restricting the user to see his records only. Now the Customer dimension has another Employee attribute. Based on the…
jay
  • 3,699
  • 7
  • 28
  • 28
4
votes
3 answers

SSAS measure value aggregate error

I have a Fact table with the following rows When I process my cube I want results like this : However when procession my cube I get the following results: I have fee rate (hourly rate) as a measure but it is summing the values when LineID is the…
evoandy
  • 630
  • 4
  • 16
  • 31
4
votes
2 answers

In MDX, how is the hierarchy chosen when referencing the All member?

I have a cube with a dimension containing a parent-child hierarchy and several non visible attributes. The only way this dimension is supposed to be queried is via the parent-child hierarchy. My problem is how the following MDX name is resolved…
Ndech
  • 965
  • 10
  • 21
4
votes
1 answer

Difference in results while using .CHILDREN and .ALLMEMBERS in an MDX statement

I have two almost similar MDX queries, in one I am using .CHILDREN and in other .ALLMEMBERS. First one returns no rows, the second one returns two. Please help me in understanding why! Query 1 select [Measures].[Claim As Of - Count] on 0, [Accident…
SouravA
  • 5,147
  • 2
  • 24
  • 49
4
votes
2 answers

How to change the date format on SSAS 2012

I have deployed an SQL Server 2012 on a Windows Server en-us. Now my dates on Analysis services are in the American format (MM/dd/yyyy). the company is not American, therefore I would like to change it to yyyy-MM-dd or dd-MM-yyyy, how can i do…
SQL.injection
  • 2,607
  • 5
  • 20
  • 37
4
votes
1 answer

How to create a separate measure group for the distinct count

I am adding distinct order count measure to the cube. I have to place it in a separate measure group for better performance When I click on "new measure group" button, I am presented with a dialog box "select a table from the source view" . My…
user2374904
  • 41
  • 1
  • 3
4
votes
1 answer

The dimension '[Time]' was not found in the cube when the string [Time].[Year], was parsed

[Time].[Year] attribute's defaultMember property is set to tail(FILTER( [Date].[Year].members, not ISEMPTY( [Date].currentmember )), 1).item(0) When I try to browse the cube, I am getting an error: DefaultMember(Date,Year) (1,14) The…
ob213
  • 494
  • 1
  • 8
  • 19
3
votes
0 answers

IIF() function not properly working while using in MDX query

I need to get calculated measure values based on conditions. Am having the below data in my cube I have created below calculated measure using IIF() function IF([Title] = "Sales Representative",[Reseller Order Count],0) I have tried with below…
TAMILARASAN R
  • 225
  • 1
  • 6
1
2 3
…
12 13