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
3
votes
2 answers

Subselect vs Slicer in MDX

If I want my results to be evaluated in the context of any tuple in MDX, but don't want this tuple to be part of the results, I use either of the below two options. 1. SUBSELECT SELECT [Measures].[SomeMeasure] ON 0, [DimName].[HierName].children ON…
SouravA
  • 5,147
  • 2
  • 24
  • 49
2
votes
1 answer

How to use multi level hierarchy names in MDX query

I need to use the dimension field under the 2 hierarchies i.e., one hierarchy under another hierarchy in the MDX query. Am having the below hierarchies/data in my cube: I need to use the highlighted [Country] field in the MDX query. Please find the…
TAMILARASAN R
  • 225
  • 1
  • 6
2
votes
0 answers

Adding WHERE condition in "Calculations" tab of SSAS Cube Designer

I have an existing calculated measure in my SSAS cube [Total Hours]. The expression for this is: ([Measures].[working Hours] + [Measures].[working minutes]/60) I have to create a new Measure by adding a where condition to the above calculated…
SQLNEWBIE
  • 21
  • 1
2
votes
0 answers

SSAS MDX: Time Calculation with a date range

In my cube, I have a Scope statement for the Previous Year Same Period [PY SAME Period]. ([Time Calculations].[PY Same Period]= Aggregate( CrossJoin ( {[Time Calculations].[Current Period]}, PARALLELPERIOD( …
xanhdieu
  • 43
  • 3
2
votes
1 answer

How to process dynamic partitions in SSAS

How to process dynamic partitions in SSAS Hello Everyone, I am new to SSAS, here is my case, I have a view table i.e., dbo.table which is having data from 2016 to 2018. By using dbo.table view i created one partition named as vwTable. Now I want to…
Chandana Puppy
  • 133
  • 1
  • 9
2
votes
0 answers

SSAS OLAP create a dimension with dynamic attributes

It is possible to create a dimension in a OLAP cube where the attibutes of this dimension are dynamic? For instance, today I can have the attibutes A | B | C | D and tomorrow I can have the attibutes A | B | C | D | E. Thanks in advance!
Ricardo Castro
  • 157
  • 13
2
votes
1 answer

SSAS Data Source View Relationship

I need to get all the relationships in my SSAS cube Data Source View between Fact and Dim tables. I've around 15 Fact tables and linked dimensions to it. Is there any MDX query to get the relationship other then doing it manually
Arvind
  • 192
  • 1
  • 10
2
votes
1 answer

Power BI Service Analysis Services database connection string

The Power BI Service "Analyse in Excel" feature produces an .odc file that is exported, downloaded onto local machine, and when executed which opens Excel, creates Excel cube and Pivot Table using the Power BI data. I have been trying to use the…
curtisp
  • 2,227
  • 3
  • 30
  • 62
2
votes
3 answers

SSAS Tabular Model Error: Object reference not set to an instance of an object. While trying to add tables to the tabular model

I'm trying to create my first SSAS Tabular model. I'm following the steps mentioned in following tutorial: https://msdn.microsoft.com/en-us/library/hh231690.aspx While trying to load the tables to the model, I get the following…
MSBI_Student
  • 21
  • 1
  • 1
  • 5
2
votes
1 answer

how to remove 'Total' from excel while check ssas cube data

the rank is also using Total value of the column. how to remove that. it's a calculation. +---------------------+------------+------+ | Row Labels | Change | Rank | +---------------------+------------+------+ | ADDERALL XR |…
Anil
  • 39
  • 2
2
votes
1 answer

Tableau, SSAS and MDX

We have a Tableau dashboard that consist of 4 worksheets. The datasource is a SSAS and there's some calculated members (MDX) and a parameter (measure selector) used in the worksheets. Placing the worksheets in a dashboard and running SQL Profiler or…
Jan M
  • 43
  • 2
2
votes
1 answer

The Axis0 function expects a tuple set expression for the argument

I just want to get the invoices distinct count of sales on March. I got this MDX query. My MDX Query: select distinctcount([Measures].[Sales #]) on columns, --[Measures].[Sales #] on columns, non empty ([Customer].[Store Group].[Store Group]) on…
good-to-know
  • 742
  • 3
  • 15
  • 32
2
votes
1 answer

MDX - NON EMPTY function faster?

I was under the assumption that NON EMPTY clause must be avoided whenever possible. So, I was in for a shock when I accidentally found that it actually made the query much faster! Sample this: select [Measures].[Count Of Requests] on…
SouravA
  • 5,147
  • 2
  • 24
  • 49
2
votes
1 answer

Associate measure group with 2 role playing dimensions

I have two fact tables – charges and payments and both of these fact tables are in the cube (as measure groups). i have one date dimension in the cube and 2 role playing date dimensions that are built off of the same date dimension: charge date…
sam
  • 139
  • 3
  • 14
2
votes
0 answers

Independent Date Dimension connected to a cube

I would like to answers to one business requirements. I create a cube that models the following event : a customer send a product from an agency to another customer who receives it in another agency. So I have a fact table with only two…
user3452538
  • 21
  • 5
1
2
3
…
12 13