Stack Overflow
Stack Overflow

Questions tagged [ssas-2008]

Microsoft SQL Server Analysis Services 2008

205 questions
0
votes
1 answer

Processing performance hit in SSAS with 2000+ partitions in 2008 R2

I am looking into the performance hits in processing time when increasing the number of partitions in a cube. I realise from http://technet.microsoft.com/en-us/library/ms365363.aspx that in theory it can be 2+ billion however I expect there is still…
Sara
  • 612
  • 5
  • 21
0
votes
0 answers

Analysis Services measure has no data

I have an analysis services 2008 R2 cube that is not returning data for one of the measures. The data source for the measure is a view that has multiple union statements. I have other measures in the same cube that have views for a data source…
Jek Ng
  • 3
  • 3
0
votes
1 answer

SSAS update the cube while the underlying data is updating

Can the underlying data being used by the SSAS cube be updating while the cube is updating? We process our cube in full once a week to clean it up (process update and process indexes during the week). However, there is a demand to process the…
TML
  • 1
0
votes
1 answer

SSAS All member questions

Let's say we have a Product dimension with three attributes: ProductID (Key) Color Category It seems each attribute has an All member. Each All member is independent? I mean it is technically posible for the All member of Color attribute to have a…
Eduard
  • 664
  • 2
  • 14
  • 26
0
votes
1 answer

Getting data from SSAS cube using ADOMD XMLReader

I have a cube and I am trying to retrieve data using following code. I don't know the number of columns and rows query will return. I just want to read value of each column going over each row. void OutputDataWithXML() { //Open a…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
0
votes
1 answer

calculate percentage of individual categories in MDX

I want to calculate percentage of individual Categories, Here is my mdx code. WITH MEMBER [Measures].[Individual_Total] AS ([DIM RATING STRINGS].[LABEL]*[Measures].AGG_RATING Count]) SELECT NONEMPTY { [Measures].[AGG_RATING…
user999896
  • 129
  • 2
  • 6
  • 21
0
votes
1 answer

Caching dimension and attribute details

I am using ASP.NET MVC 3.0 and use ADOMD class to get the dimension names and attribute names. This is a heavy operation and multiple users are using this application. I am wondering which is the best caching technique I can use? I want to create a…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
0
votes
1 answer

SSAS Distinct sum for connected Fact Table

I have 2 Fact tables with relations Fact Flight 1:many Fact Cost. Also I have separate dimensions for Fact Flight and Fact Cost. I want to make Fact Flight measures to be filtered by Fact Cost dimensions and vice versa. Is it possible in SSAS?
Anton L
  • 412
  • 4
  • 12
0
votes
1 answer

Abitrary Shape Of Sets Error when defining Partition Slicers

I'm trying to adapt the concept of designing Slicers within my Cube for associated Partitions. This is a practice that I typically have avoided because of familiarity with the Auto-Slice concept where creating Slicers are treated more so as options…
Mark
  • 1,667
  • 2
  • 24
  • 51
0
votes
1 answer

getting dimenison processing error; Incorrect key file for table '/var/tmp/mysql.VArBWG/#sql_aa0_8.MYI'; try to repair it

when i process a dimension a got this error.. Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Incorrect key file for table '/var/tmp/mysql.VArBWG/#sql_aa0_8.MYI';…
neha prajapati
  • 69
  • 6
0
votes
1 answer

Getting actual executin time/duration of MDX query

How can I get the actual execution time or actual duration taken by an MDX query to run? I am not interested for compiling, parsing, rendering results etc. I am only interested for the execution time. In sql profiler, I get two columns one is…
Ahmed Tanvir
  • 187
  • 7
0
votes
2 answers

Cube of people that are alive during a given time period

I have a requirement to have data analysed based on a range. The best example would be: give me the number of people that were alive on a given period (time dimension). I know how to deal with the "Born date". I know how to deal with the "Death…
Patrice Calvé
  • 674
  • 6
  • 12
0
votes
1 answer

Ordering by a generic calculated measure results in infinite recursion? (MDX)

I need to write a calculated measure that would show a share of Measure1 comparing to the total sum by any given dimension. I managed to do it like this: CREATE MEMBER CURRENTCUBE.[Measures].[Test] AS [Measures].[Measure1] / ( AXIS( 1 ).ITEM( 0…
Dmytro Shevchenko
  • 33,431
  • 6
  • 51
  • 67
0
votes
1 answer

How to backup and restore only one cube in SSAS database

I have a cube in a test environment which is in an SSAS database with other non-related cubes. Since I'm testing my ETL and Fact table, I need to truncate the Fact and re-run the ETL and cube multiple times but I need to have backups of previous…
Frank Goortani
  • 1,407
  • 17
  • 26
0
votes
2 answers

How to get the name of invisible attributes and user defined Hierarchies using MDX?

I have a cube with some dimensions. There I have a dimension 'Product' which has some attributes and user defined hierarchies hidden. I do not know which attributes are hidden. Is there a way to write an MDX to get the invisible attributes and user…
Luniam
  • 463
  • 7
  • 21
1 2 3
…
13
14