Stack Overflow
Stack Overflow

Questions tagged [ssas-2008]

Microsoft SQL Server Analysis Services 2008

205 questions
2
votes
1 answer

MDX / SSAS - Need flexible percent of parent measure

I’ve been searching for hours on this and I’m just not adept enough at MDX to know if I’ve come across the solution yet. Everything I tried has not worked. The situation is, I need a “percent of parent” measure. In this example, the only thing I…
Jeffrey Bane
  • 592
  • 1
  • 10
  • 40
2
votes
0 answers

MDX SUM function and NULL values

I'm trying to create some reports for Team Foundation Server 2010 using underlying SQL Server 2008 Analysis Services database. The cube 'Team System' is the one that comes with TFS 2010 Reporting. My problem is. I tried to use StateChangeCount…
aguyngueran
  • 1,301
  • 10
  • 23
2
votes
2 answers

VISUALTOTALS and UNION in MDX inconsistent

I have a problem with a MDX request: The following query gives me the good partial results WITH SET [Paiments Encaisse] AS { [Type Paiement].[Type Paiement Id].&[13] ,[Type Paiement].[Type Paiement Id].&[20] ,[Type Paiement].[Type…
Johan Buret
  • 2,614
  • 24
  • 32
2
votes
2 answers

How to Create a Hierarchy in SSAS when duplicate attributes exist at the Root

I have a Dimensional table structure which resembles the following: Ideally the hierarchial representation should be CodeClassDesc --> CodeDesc So A would be a Parent to A and B; B would be a Parent to A, B and C in my Analysis Server Cube. The…
Mark
  • 1,667
  • 2
  • 24
  • 51
2
votes
1 answer

million rows dimension in ssas cube

I have a large dimension in my cube which has 5 million rows. when I drag that dimension column in excel to view metric value it times out. Is there any way I can limit the data dynamically or selecting only top 10K rows when that large dimension is…
user1220540
  • 39
  • 2
  • 8
2
votes
1 answer

Defining SSAS roles in other domain

I am developing SSAS cubes for a customer. Now I am developing on my PC in my company' domain. Is it possible to define roles and security options based on my customer's domain and active directory groups? Thanks
Andi
  • 487
  • 3
  • 6
  • 22
1
vote
1 answer

SQL Server 2008 r2 MDX GetDate()

I am trying to determine what the language equivalent of Select getdate() is for MDX. I want to simply get the date-time at the server in question, not actually query any data. This is for a kind of smoke test, so I need to understand the most…
Snowy
  • 5,942
  • 19
  • 65
  • 119
1
vote
1 answer

How can I write an MDX query in Microsoft Reporting Services that displays measures names on Rows?

How can I write an MDX query in Microsoft Reporting Services that displays some measures names in the fact table and total measures (amount) associated to that measure?, and measure names should be on the rows. For example, a fact table has…
Momba Musende
  • 77
  • 1
  • 3
1
vote
2 answers

How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?.

How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?. I have a data cube designed and deployed on Microsoft SQL Server Analysis Services R 2. I have a customer…
Momba Musende
  • 77
  • 1
  • 3
1
vote
1 answer

How can i get Server Name,ID in XMLA file?

I want to create a Dynamic XMLA file where i want to process the cubes on different servers . This is the script i have generated from Mangement studio. but i could not able to see the Server node in the XMLA file ( , ) How can i get this from…
user1049198
  • 13
  • 1
  • 4
1
vote
0 answers

What would not allow Excel connection to SSAS 2008

2 boxes side by side same Sys Admin user credentials. XP SP3 with Office 2007 Pro and Native Client 10 Win Server 2008 with SQL 2008 Enterprise SSAS on 2nd instance Box 1 connects easily every time to OLAP Box 2 Fails every time with this: Errors in…
user575997
  • 11
  • 3
1
vote
0 answers

Time intelligence based on different year types

I am developing an OLAP cube using SQL Server 2008 SSAS. I have a dimDate table, and my fact data needs to be sliced by two different year types. First is calendar year, that is January 1 to December 31 Second is manufacturing year of agricultural…
Tal Aruety
  • 23
  • 5
1
vote
1 answer

How can we get the usage of measures and dimensions in SSAS cube?

We are struggling to find the usage of measures and dimensions in SSAS cube. Objective: To have a statistical dashboard to find the unused or most used measures and dimensions. I have got help from…
Vikas Gupta
  • 1,293
  • 1
  • 15
  • 21
1
vote
1 answer

mdx query to calculate average between date range

I am hoping to get some help to calculate the average between date ranges. Start date would be the time dimension and end date = start date - 13. Or is there a way we can use iff statement to calculate the average with date range?
SKenneth
  • 19
  • 11
1
vote
0 answers

How to improve the reads from OLTP reprocessing Dimensions Attributes in SSAS?

I'm working to reduce the time that we spend to reprocess our SSAS cube. The slowest part is processing the dimension (Process update or process add), in specific the bottleneck is when SSAS is reading from OLTP. When I open profiler I can see the…
Idania Arenivar
  • 41
  • 4
1 2
3
…
13 14