Analysis Services

• Topics

  Started by

  Posts

  Last post

• Error while establishing SSAS OLEDB connection for Excel to export cube

  Hi Guys, I have designed a Cube in remote server Now, I want to export Cube reports in Excel 2007. …

  bhushan_juare

  1 replies

  14 years ago

  By: amit_gupta01

• Date dimension in not refreshing

  Hi, I'm having a cube with multiple dimension and one of the dimension is for date and based on the…

  G R Kumar

  2 replies

  14 years ago

  By: amit_gupta01

• Scheduled MOLAP in settings

  Hi All, I have a cube and set to scheduled MOLAP every 24hrs..Every partition shows cube is process…

  saprajun

  4 replies

  14 years ago

  By: amit_gupta01

• T-SQL to MDX

  Hi All I am new to writing MDX so please forgive my ignorance. I was wondering if anyone could reco…

  Ant-Green

  4 replies

  14 years ago

  By: Ant-Green

• Need Simlpe Clarification in MDX

  I had a reqier ment as shown Hierarchy Country.States.City and the measure in Population I need to …

  radha.k.ds

  5 replies

  14 years ago

  By: jeff122877

• Formatting the color for a specific hierarchy in a cube

  Hi, I want to change the color for values if they are negative, eg. < 500, but this should only …

  nicklas.jonsson86

  1 replies

  14 years ago

  By: Kees Beimans

• sysobjects for ssas

  In SQL Server, I can query sysobjects, syscolumns, syscomments etc to get information about the obj…

  DVaughan 11378

  2 replies

  14 years ago

  By: DVaughan 11378

• Trying to write MDX statement to do a custom running total

  Here's where I am WITH MEMBER Measures.[New Incident Running Total] AS 'SUM([Time of Day].[Half Ho…

  mtassin

  1 replies

  14 years ago

  By: drew.allen

• OLAP Remote backup

  <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> …

  Bobby Glover

  4 replies

  14 years ago

  By: Bobby Glover

• want to limit MDX output

  I want to limit the following code so that only "counts" > 9 are returned and I can not figure i…

  Tobar

  6 replies

  14 years ago

  By: Tobar

• MDX in a stored procedure in 2008

  Is there any way to put MDX in a stored procedure that can be called by a web front-end? I don't se…

  Tobar

  4 replies

  14 years ago

  By: bhushan_juare

• Cannot connect to analysis manager

  hi when I opened the Anaysis manager console I was unable to view OLAP servers or re…

  SQL DBA-356438

  2 replies

  14 years ago

  By: Glen Weldon Maney

• how to prove Rolap Uses Relation Database Engine...

  hi .... how to prove Rolap Uses Relation Database Engine...while executing MDX queries [font="Verda…

  miriyalasrihari

  1 replies

  14 years ago

  By: Jayanth_Kurup

• SSAS page file usage

  Hello all. I've worked with SQL for quite a while, but new to SSAS. Hopefully someone can help me…

  camaro305hp

  8 replies

  14 years ago

  By: camaro305hp

• Distinct count across multiple dimensions

  Greetings all 😀 I am alright with cubes at a basic level but adding additional functionality is a b…

  shannonjk

  2 replies

  14 years, 1 month ago

  By: shannonjk