Analysis Services

• Topics

  Started by

  Posts

  Last post

• strange behavior from Analysis service

  Hi all, so I am new to the company and working on this package that builds cubes. SQL Job constantl…

  pobeda

  2 replies

  12 years ago

  By: pobeda

• fact.date BETWEEN dimension.date1 and dimension.date2

  Hi, I am relatively new in Analysis Services and building my first cube from a DWH. I have a fact t…

  michielbijnen

  4 replies

  12 years ago

  By: Paul Williams

• Retrieving the last non-empty value and display it for each day

  Hi all, I am new to SSAS and more so with MDX and I need your help with the following scenario plea…

  all_vn

  1 replies

  12 years ago

  By: something_123

• A duplicate attribute key has been found...

  im going through an exercise book with examples of SSAS cube creation and deployment. One exercise …

  winston Smith

  6 replies

  12 years ago

  By: cabbagetreecustard

• time range dimention based on a number

  Hi I would like to create a time range dimention based on a numerical value. so I have a column in …

  erics44

  3 replies

  12 years ago

  By: erics44

• Local Cube - measure formats

  I am creating a local cube using the "CREATE GLOBAL CUBE" statement (SSAS 2005). This particular cu…

  neil ashworth

  1 replies

  12 years ago

  By: tpraveenkumarmsbi

• SSAS 2008 R2 - Drillthrough Actions

  As I am sadly also fairly new to SSAS, I am currently on a project which requires some assistance i…

  KH1975

  2 replies

  12 years ago

  By: KH1975

• 2008 - Cubes and Drilling Down

  I have an extraction from our ERP system called FinancialDetails that has the following columns: Da…

  Dennis Klemenz

  3 replies

  12 years ago

  By: Ells

• Dimension security by using MEMBER_NAME

  Hi all, In a dimension I have one attribute where the very same MEMBER_NAME occur for several membe…

  Martin_A

  2 replies

  12 years ago

  By: Martin_A

• Error in pocessing cubes

  Hi All, As part of our migration project our application is migrating from SQL server 2005 SP1(Wind…

  Avik Roy

  2 replies

  12 years ago

  By: Avik Roy

• Drill down with caculation different for each level

  In a cube I have a measure that is aggregated in function of its level in the hierachy : for exempl…

  jacques.dubois

  1 replies

  12 years, 1 month ago

  By: Scott Murray-240410

• An MDX count operation doesn't listen to Excel Filter

  I'd like to be able to create a semi-additive measure using SSAS Standard Edition. I have a measure…

  jdkblade

  1 replies

  12 years, 1 month ago

  By: jdkblade

• Cube processing failures in sql server analysis services 2008 r2 sp2

  Hello all, Does anyone know how to debug cube processing failures in sql server analysis services 2…

  Scott Keatinge

  3 replies

  12 years, 1 month ago

  By: jakob_beck

• User access issue

  Hi everyone, I am trying to allow a user to read a cube, and I add him to the one and only role tha…

  shahgols

  1 replies

  12 years, 1 month ago

  By: Koen Verbeeck

• Record count/hash compare

  Hi guys, have any of you ever put a structure/solution in place so you can audit a cube? Being able…

  Ian C0ckcroft

  1 replies

  12 years, 1 month ago

  By: Koen Verbeeck