Analysis Services

• Topics

  Started by

  Posts

  Last post

• Dynamic Filtering based on Member properties

  I've not done any serious MDX for about 18 months and this is starting to bug me. I want to create…

  Jason-299789

  3 replies

  11 years, 3 months ago

  By: Nevyn

• EXISTS not returning the same number of rows as WHERE

  Hi, I am trying to write this MDX query. I am trying to select the Number of planned jobs (open, cl…

  LittleKitten1978

  1 replies

  11 years, 3 months ago

  By: Nevyn

• Book Recommendation

  Can anyone recommend a good SSAS book? I'm looking for the following; - Exclusively SSAS coverage(n…

  rmatthias001

  1 replies

  11 years, 4 months ago

  By: Koen Verbeeck

• group by clasue in mdx

  Hi Friends i have small doubt in mdx query. table having data like below table name : patieninfor…

  asranantha

  4 replies

  11 years, 4 months ago

  By: asranantha

• dimension deployement error

  Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. The da…

  mmeenap

  3 replies

  11 years, 4 months ago

  By: emiranda 59653

• Cannot create an instance of OLE DB provider for linked server

  Hi all, When i log in to my SQL Server Management Studio with windows authentication and try to ru…

  sachinbb

  3 replies

  11 years, 4 months ago

  By: dfranklet

• Cube Replication (Duplication) using same data source & Enabling Detail Level Member in the Duplicate OLAP

  Hi Guys, I have 2 reporting systems, one which is our OLAP based source systems and one where we co…

  venkyzrocks

  2 replies

  11 years, 4 months ago

  By: venkyzrocks

• Calculate cumulative percentage change

  Hi, I was able to create an MDX calculation that generates percentage changes between time periods …

  scottcabral

  1 replies

  11 years, 4 months ago

  By: PB_BI

• OLAP Cube Calculated Averages

  I was hoping someone could shed some light on this question: I have an OLAP Data cube using the fol…

  Marco Barroso

  1 replies

  11 years, 4 months ago

  By: PB_BI

• MDX functions for rolling time periods

  Hi All: I've looked on the web and found many examples of rolling time periods that suggest doing o…

  Simon Norton

  1 replies

  11 years, 4 months ago

  By: Simon Norton

• Unable attach analsysis service database without detach log file

  Hi Post recycle of Analysis Service we found one of the database went missing. So we tried attachin…

  SUBRAHMANYA HEDGE

  3 replies

  11 years, 5 months ago

  By: stefan.zhelev

• Calculated member formula for All member is not SUM of children

  Hello everyone, I am working on a proof of concept to move some heavy analytical calculations into …

  cliffb

  2 replies

  11 years, 5 months ago

  By: write2mmk14

• Create single cube from multiple identical OLTP databases

  I need to create a single cube from about 50 separate, but identical relational databases, each rep…

  don.schaeffer

  4 replies

  11 years, 5 months ago

  By: don.schaeffer

• Trying to create Hierarchy in BIDS from DimTable

  Hi - I am trying to create a hiearchy from a Dim Table linked to the SQL DB and I'm having difficul…

  plmarshall

  1 replies

  11 years, 5 months ago

  By: plmarshall

• SSAS Cube on one server and SQL Server DB on another - Connection Issues

  Hi Guys - I data modeled a star schema data mart in SQL Server 2008 and I've created a cube in BIDS…

  plmarshall

  4 replies

  11 years, 5 months ago

  By: plmarshall