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
2
votes
1 answer

SSAS attribute hierarchy not usable as row label in Excel

I have a Time dimension that has Fiscal and Gregorian hierarchies that I'm trying to use (either, not both) as row labels in an Excel pivot table. I can add either as a filter, but Excel will not allow me to drag them into the row labels box. Each…
Ryan Schmitz
  • 51
  • 2
2
votes
1 answer

MDX LastPeriods for Rolling Count Null values

I have created a calculated member in my cube to figure out the event count for a 12 month rolling period. I have a measure called Event Count I have used the LastPeriods function to do this. However, I am having a problem when I have a month that…
Gavin Campbell
  • 21
  • 1
  • 2
2
votes
1 answer

How can I create a calculated measure based on a filtered dimension?

I'm relatively new to MDX (in the process of ordering a book just now) and having a crack at creating a calculated measure, which should sum a value from one of my Fact tables, based on a set range of dates (from my Time dimension) which should be…
GShenanigan
  • 5,409
  • 5
  • 38
  • 48
2
votes
2 answers

Need Hardware Sizing guidelines for SSAS Tabular server

Are there any good sources of hardware sizing guidelines for servers running SSAS Tabular? Something along the lines of "if your models are estimated to be this big (in terms of memory) and you're expecting and average x-number of simultaneous…
Bill Anton
  • 2,920
  • 17
  • 23
1
vote
1 answer

Display table names

I have a tabular model cube with Compatability Level SQL Server 2016. I assigned the columns and the measures in two different display folders. When analyzing the cube with Excel, the columns and the measures are displayed in two different display…
hana
  • 101
  • 10
1
vote
0 answers

How to use date range in IIF function in MDX Query

Am having 2001,2002 and 2003 years of data in the SSAS server. Without using where clause and filters I need to get the aggregated data using the IIF function in the MDX query for a particular date range. I have referred to many sites but I didn't…
TAMILARASAN R
  • 225
  • 1
  • 6
1
vote
1 answer

Issue in Partition in SSAS tabular model with DirectQuery Mode

I am trying to create a sample partition to a tabular model database in DirectQuery mode, and I got the following error after setting the filter and trying to import: "Failed to save modifications to the server: Error returned: 'A table that has…
Techchamp Pgm
  • 137
  • 11
1
vote
0 answers

Number or Results and WITH MEMBER Calculation interacting weird

In our MDX Queries, we use a template like the following WITH MEMBER . SELECT SUBSET . FROM (SELECT . FROM .) a lot. What this particular query should do (and does!) is list all product variants matching a filter, and give the sales amount for it…
Ralf
  • 538
  • 1
  • 6
  • 17
1
vote
0 answers

non shrinkable memory in SSAS Multidimensional keeps growing

analysis services non shrinkable memory is up to 48Gb . Does anyone know how to shrink this back down, or what might cause it? it keeps growing by the day.
Naoufal Touailat
  • 33
  • 1
  • 4
1
vote
1 answer

How to get list of DataTables metadata used in SSAS DSV?

I was wondering if there's a simple way to extract a list of all the tables description from the Data Source View at SSAS? I've been so far been playing around with this simple DMV-query to get the cube metadata: SELECT * FROM…
Chris A.
  • 11
  • 2
1
vote
1 answer

How to retrieve a measure from SSAS tabular project using DAX script in SSMS?

I have a tabular project with one fact table and few dimension tables. The fact table Fact1 has a measure called Number_of_Children. How to retrieve that measure using EVALUATE statement is SSMS? evaluate(values('Fact1…
BenThomas
  • 53
  • 5
1
vote
2 answers

XML for Analysis parser: The restriction version is not recognized by the server

TITLE: Query Designer I've just started to teach myself SSAS. I am using SSDT 2015 with a 2012 database. I've created my first cube and I've been able to process and deploy the cube as well as view the metadata (measures and dimensions). I have…
Juan
  • 11
  • 2
1
vote
0 answers

SSAS Cube Filtering Data

I've working on SSAS cube creation first time on real data(Although had little hands on experience on AdventureWorksDW08).I also have gone through the details for creating basics cube and all but have little question as to which are the…
Jitesh Vacheta
  • 85
  • 1
  • 13
1
vote
1 answer

How can we get the usage of measures and dimensions in SSAS cube?

We are struggling to find the usage of measures and dimensions in SSAS cube. Objective: To have a statistical dashboard to find the unused or most used measures and dimensions. I have got help from…
Vikas Gupta
  • 1,293
  • 1
  • 15
  • 21
1
vote
0 answers

one to many dimensional relation ssas

Need your help or suggestions over my case here in SSAS modeling I am basically struggling with 4 tables, Customer, CustomerPhone, CustomerEmail, CustomerBusinesses. Providing the sample data below, only the dimension Customer is linked to all,…
Harsha
  • 113
  • 9
1 2
3
…
12 13