Stack Overflow
Stack Overflow

Questions tagged [ssas-2008-r2]

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. This tag should be used on questions specific to the SSAS implementation in SQL Server 2008R2.

SQL Server Analysis Services (SSAS) is part of Microsoft's SQL Server system. It provides Online Analytical Processing (OLAP) and Data Mining functionality.

This tag should be used on questions specific to the SSAS implementation in SQL Server 2008R2.

See also , .

9 questions
2
votes
2 answers

Incorrect results in TOPCOUNT query for some attributes

I am trying to find out which year had the highest reseller sales across each of the State-Province. I am using Adventure Works DW 2008 R2 database. Here is the query that I have got - SELECT { [Reseller Sales Amount] } ON COLUMNS, { Generate ( …
VKarthik
  • 1,379
  • 2
  • 15
  • 30
1
vote
2 answers

How to set format_string dynamically in scope?

I have 3 measures: [Measures].[Some Count] with FORMAT_STRING="#,0" [Measures].[Some Amount] with FORMAT_STRING="Currency" [Measures].[Some Percent] with FORMAT_STRING="Percent" SCOPE is used to change values of all measures, let's say this…
Alex Peshik
  • 1,515
  • 2
  • 15
  • 20
1
vote
1 answer

SSAS MDX Parameter Error

In SSRS, I've created a dataset connecting to an AS datasource. I've written up a MDX statement in the query designer and it works fine, until I substitute STRTOMEMBER('[....]') with STRTOMEMBER(@Parameter1) I've also got @Parameter1 defined in…
user172839
  • 1,035
  • 1
  • 10
  • 19
1
vote
0 answers

if I plan to change the sort order of my attributes, do I need to use flexible or rigid attribute relationship type

I want on occasion to add new members to an existing dimension. Sometimes the new member will be inserted into the existing sort order by increasing by 1 the integer sort values of the member currently occupying that sort position and those that…
JM Hicks
  • 1,282
  • 1
  • 11
  • 22
1
vote
0 answers

How can I connect pentaho to SQL Server 2008 R2 Analysis Service without using Mondrian schema using Driver org.olap4j.driver.xmla.XmlaOlap4jDriver

How can I connect to SQL Server 2008 R2 Analysis Service without using Mondrian schema using Driver org.olap4j.driver.xmla.XmlaOlap4jDriver? I can connect with SSAS and getting data using preview option at Spoon >> Transformation I am following this…
Maneshwar Meel
  • 31
  • 1
  • 3
0
votes
1 answer

SSAS role-playing dimensions and two measure groups

I have two measure groups in cube: Facts1 (id1, measure1, dim1, dim2) Facts2 (id2, measure2, dim1, dim2) And I have two dimensions: Dim1 Dim2 All is fine.. In the finall cube I have two measures and two dimensions. Now I want to use Dim2 as…
huhu78
  • 379
  • 2
  • 13
0
votes
1 answer

ssas hierarchy member and hierarchy level members difference

The ssas dimension, Period consists of an hierarchy, [period calendar] and there are 2 levels [period year] and [period name]. There are members under [period name] (level members) and also, there are members under [members] folder. What are the…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

Time Calculation + Measure Calculation combined giving incorrect answer (SSAS)

(using SSAS 2008r2, working in Bids) I've run into a confusing issue regarding the interaction between a calculated time period member and a calculated semi additive measure. I have a "Time Period" dimension built along the lines of the article "A…
Lefty
  • 426
  • 3
  • 10
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