Analysis Services

• Topics

  Started by

  Posts

  Last post

• Migrating SSAS cubes to different instasnces

  Dear all I am migrating from server A to Server B an entire SSAS project with different cubes. The …

  kamamusic

  5 replies

  11 years ago

  By: PB_BI

• Find last time all cubes were processed

  Is there an easy well to find out the last time all the cubes on a server were processed? I've got …

  Elizabeth.Block

  14 replies

  11 years ago

  By: Elizabeth.Block

• Conditional Measure in DAX

  Hi all, I have a measure that is a running total in a selected Month, as shown below; CumulativeCou…

  mm7861

  7 replies

  11 years ago

  By: mm7861

• Do you need a cube if you have a Data-mart and PoverPivot/Power Query

  Hi Guys, I have a question to ask. I have been using SSAS and Cubes for about a year now. I admit m…

  paulbuxton_bucko

  1 replies

  11 years ago

  By: xsevensinzx

• The XML for Analysis request timed out before it was completed.

  I'm supporting a SQL 2008 SSIS Package which is getting the error below intermittently when executi…

  Steve-443559

  2 replies

  11 years ago

  By: Sl33py

• Converting @ISMBR into SSAS MDX query

  Hi, How to convert Oracle @ISMBR function into SSAS MDX Query?. I tried like IIF( Count( Int…

  saravanakumar.G

  1 replies

  11 years ago

  By: PB_BI

• Calculated Measure Comparing 2 Dimension Values

  I've scoured several boards but have not been able to find this exact question or unable to get res…

  ravi_k

  2 replies

  11 years ago

  By: ravi_k

• Calculated Member - Current month

  Good Day My situation is that the script below is for a calculated member but I need to add a condi…

  ttdeveloper

  4 replies

  11 years ago

  By: ttdeveloper

• Aggregate function for a measure - Count or Sum

  I have a cube for counting # of members in different ways. The measure is "Member Count", which is …

  seaport

  2 replies

  11 years ago

  By: seaport

• Fact Records Not Being Converted to Unknown Members

  I have a dimension dim.MethodInfo. I select from it as a Named Query inside my Data Source View. …

  stephenbaka

  1 replies

  11 years ago

  By: Martin Schoombee

• Refreshing SSAS cube

  Hi I wanted to do a incremental load of my cube. My sql query for taking delta is this. select colu…

  VRT

  13 replies

  11 years ago

  By: VRT

• Roll Up Issue - 2 Companies, Same Teams

  Hi I'm having an issue that is probably caused by my inexperience. We have a Cube that tracks calls…

  febagames

  3 replies

  11 years ago

  By: PB_BI

• Process Dimensions Dynamically with SSIS

  Hello, Wasn't sure if I should post here or under SSIS or Data Tools, but I'll start here. I'm sett…

  boumerlin

  3 replies

  11 years ago

  By: PB_BI

• Using XMLA to perform batch deletion of olap databases

  Has anyone written a script that will go through all the olap databases and delete them? I am looki…

  kwiggans

  4 replies

  11 years, 1 months ago

  By: wzkmafi

• M:N Dimension Relatioship

  Good Day I have a question/issue on a dimension I created in SSAS. See attached files (Dimension)…

  ttdeveloper

  4 replies

  11 years, 1 months ago

  By: ttdeveloper