Analysis Services

• Topics

  Started by

  Posts

  Last post

• AdventureWorksDW-No Role Playing Dimensions?

  I'm trying to read up on SSAS and going through some tutorials. They show the DimDate and FactResel…

  Maxer

  2 replies

  11 years, 5 months ago

  By: Maxer

• SSAS Deployment Utility

  Has anyone had any success using the SSAS Deployment Utility for SQL Server 2012 (Microsoft.Analysi…

  Lempster

  17 replies

  11 years, 5 months ago

  By: TheComedian

• Convert a sales value to the reference currency with the exchange rate of a specific date

  I Have 2 Dimensions: Time and Currency I also have to fact tables, exchange rate and sales Both fac…

  Paul Hernández

  1 replies

  11 years, 5 months ago

  By: Paul Hernández

• Calculating measure for the current month of Previous Year

  Hello, I would like to calculate measures in MDX for the current month of the previous year. Exampl…

  yhafraoui

  2 replies

  11 years, 5 months ago

  By: yhafraoui

• Would this be an appropriate use for SSAS?

  We are looking at creating a "dashboard" for our customers. Our customers use our service to submit…

  Maxer

  3 replies

  11 years, 5 months ago

  By: Maxer

• Building a Data Mart with an Inmon’s architecture for SSAS cubes

  Hi folks, My questions today are about basic design of a Data Warehouse Solution. In my organizatio…

  Paul Hernández

  2 replies

  11 years, 5 months ago

  By: sneumersky

• Cube Dimension data restriction to users in SAP BO

  Hi Everyone, I am posting this to get help on urgent basis on dimension member data restriction We …

  Avik Roy

  1 replies

  11 years, 5 months ago

  By: sneumersky

• How to add where clause/filter into calculated member in mdx

  I am new to MDX. I have below query: WITH MEMBER [Student Study Length Hours] AS ([Measures].[Study…

  sqlblue

  1 replies

  11 years, 5 months ago

  By: sneumersky

• Unable to filter the data for multiple time selections by dimensions

  Hi to all, I am new in MDX, i have a problem with my MDX query. Calculated Member Logic: SUM((OPENI…

  nagendra2509

  1 replies

  11 years, 5 months ago

  By: sneumersky

• Creating Aggregations Post Deployment of Cube ?

  Hi Friends, Is there a possibility to create Aggregations after the Cube has been deployed. I recol…

  syedathariqbal

  4 replies

  11 years, 5 months ago

  By: sneumersky

• Calculated member problem -> to show Full year data for each month

  Hi, I do have a following problem: Time dimension with hierarchy [Time].[Year - Month] with levels …

  piggy69

  2 replies

  11 years, 6 months ago

  By: piggy69

• MDX Query using a date range

  Hi All. Yet another newbie to SSAS here. I'm trying to write a query which select data about finan…

  thepotplants

  2 replies

  11 years, 6 months ago

  By: thepotplants

• Unknown Member & Null Processing

  Hi Forgive me - this is probably a very basic question. I have followed Kimball methodology by incl…

  ianpmclarke

  4 replies

  11 years, 6 months ago

  By: Suresh.Utham

• SQL OR with MDX

  I have a Measure called Supplier Number in the cube. The Supplier table acts as a Dimension as well…

  rockybhai

  2 replies

  11 years, 6 months ago

  By: //Ravi

• Training kits for MCTS 70-466 and MCTS 70-467

  I want to appear in test below. MCTS 70-466 (Implementing Data Models and Reports with Microsoft SQ…

  azhar.iqbal499

  5 replies

  11 years, 6 months ago

  By: Jim Mackenzie