Stack Overflow
Stack Overflow

Questions tagged [ssas-2008]

Microsoft SQL Server Analysis Services 2008

205 questions
3
votes
1 answer

MDX: IIf condition on the value of a dimension is always false

I am trying to produce a different output in a column dependent on whether the value of a dimension [Scenario].[Option] is +5 which I've tried to achieve using the IIf function. WITH MEMBER [XorY] AS ( IIf([Scenario].[Option] = +5, 'X', 'Y') …
Neo
  • 4,145
  • 6
  • 53
  • 76
3
votes
4 answers

How to sum a calculated measure?

I have a fairly complex calculated measure that works perfectly for each row of data from a cube. However, I then need a sum of those values line by line. But the behavior of calculated measures seems to be in the subtotal and total lines in Excel,…
Jeffrey Bane
  • 592
  • 1
  • 10
  • 40
3
votes
2 answers

MDX Filter by Members

This is more of a general MDX question. I want to filter those dates from the reporting date.fiscal hierarcy. I was previously using a calculated member but I just put it in the query, it doesnt return any results. SELECT { …
uh_big_mike_boi
  • 3,350
  • 4
  • 33
  • 64
3
votes
2 answers

SSAS - script partitions possible?

I was recently tasked with partitioning a large cube and I ended up creating 15 partitions on several measure groups. It's sped up the processing time considerably. This was done in BIDS on a development copy of the cube. My question is on deploying…
Jeffrey Bane
  • 592
  • 1
  • 10
  • 40
3
votes
1 answer

What are the Different types of dimensions in SSAS

I am learning SSAS now. In that I heard that there are many types of dimensions. What are those types. Like parent-child there are some more categories. Can any one explain. Thanks
Searcher
  • 1,845
  • 9
  • 32
  • 45
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
0 answers

Misleading cell security error message prevents drillthrough action on SSAS2008

I have a cube with no cell security configured, and get an intermittent problem with a drillthrough action. The cube has two measure groups: One with accounting transactions from a financials application (Oracle Financials) and one with a set of FX…
ConcernedOfTunbridgeWells
  • 64,444
  • 15
  • 143
  • 197
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

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

SSAS Dimension Attributes are not visible in Cube Browser (BIDS)

I am new to SSAS & Modifying the existing SSAS Cube to Add New Columns, Rename and Delete Existing Columns. I Made required changes in the Data Source. I Refreshed the Data Source View and able to see the new changes. I Added the new columns in the…
user1089783
  • 63
  • 2
  • 8
2
votes
1 answer

Unable to set timeout property for ADOMDConnection class

I am using AdomdConnection connection class to connect to the Cube. I am using following code. using (var conn = new AdomdConnection(ConnString)) { conn.Open(); var cube = conn.Cubes[name]; //Do…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
2
votes
1 answer

Calculated Member based on dimension attribute value

I want to make some Calculated Measures in my cube that conditionally use a value from the measure table, based on a dimension attribute value. For example: where Document Status in the Document dimension is CP, use the Committed Value measure. …
user992228
  • 39
  • 1
  • 1
  • 4
2
votes
0 answers

SSAS (Sql Server Analysis Services) UPDATE performance with multiple update statements in a transaction

Our business logic involves sending multiple MDX UPDATE statements to SSAS in a single transaction. Each update statement typically has 600-800 cells that are update. All of these updates touch the same set of measure groups within the same…
Bhanu Gotluru
  • 235
  • 2
  • 7
2
votes
0 answers

Drilling through in ssas to a dimension attribute that has hierarchy disabled

I am using SQL Server 2008 R2, developing using BIDS. I have a very large cube, with many dimensions, and I am building a drill through action. The requirement is for a very broad drill through, which includes many fields that are in the fact table…
Moshe Yossef
  • 39
  • 1
  • 4
1
2
3
…
13 14