Analysis Services

• Topics

  Started by

  Posts

  Last post

• SSAS :: MDX :: Scope Function :: Exchange Rates

  Hey all, My problem: I'm trying to create a scope function that calculates exchange rates based on …

  _Tups_

  6 replies

  14 years, 6 months ago

  By: Jason-299789

• How to change date from daywise to monthwise

  Hi, I made a cube in ssas. I am using it in the excel pivot table. When i put the date column in…

  Skybvi

  10 replies

  14 years, 7 months ago

  By: RonKyle

• MDX time range issue

  Hi i am having a database with date & time dimension separately. Data has granularity of 1 min…

  dmalviya

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• Issue regarding MDX Queries

  SELECT NON EMPTY { [Measures].[Record Count - Dim Employee AS] } ON COLUMNS, NON EMPTY { ([Date].[H…

  Ciber2010

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• Binding two separate SSRS parameter values to the same SSAS dataset

  Hi there I need to build a report that allows users to choose two months for month on month compari…

  doodlingdba

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• can we display all attributes in a dimension automatically

  Hi, Here I have a dimension that will have 10 attributes (columns). can we display all attributes i…

  suresh.muppidi

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• ASSP.dll error

  i downloaded ASSP.dll and added to assemblies(in SSMS-Database Engine) and then trying to execute …

  miriyalasrihari

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• Need MDX query to list roles and users

  Hi. Does anyone have an MDX query or any other way to list all roles and users for a given SSAS cu…

  cynthia.parker

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• Adding a column to cube partitions ( after successfully adding it to relational store / Data Source Views )

  So, have added the column to the relational store, gotten it updated in the DataSourceViews. Then, …

  j-484180

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• STANDARD ACTIONS....

  I WANTED TO KNOW ABOUT STANDARD ACTIONS IN SSAS CUBE ACTIONS LIKE.. DATASET ROWSET …

  miriyalasrihari

  1 replies

  14 years, 7 months ago

  By: Kees Beimans

• cube from 1 table

  Hi, Is it possible to make a cube from 1 table only..That table has a primary key also. Iam not …

  Skybvi

  3 replies

  14 years, 7 months ago

  By: ssills

• Adding a dimension

  Hi, I have a dimension table like Dimension table name : ReportCodesDim Columns: Id, Name, Discrip…

  suresh.muppidi

  1 replies

  14 years, 7 months ago

  By: cynthia.parker

• DIFFERENCE BETWEEN CALCULATION TAB AND KPI's TAB IN SSAS

  DIFFERENCE BETWEEN CALCULATION TAB AND KPI's TAB IN SSAS2008 [font="Verdana"]SRIHARI(:~[/font]

  miriyalasrihari

  1 replies

  14 years, 7 months ago

  By: amit_gupta01

• Cube data processing without all data present in datawarehouse

  I have a cube which contains data for two years(2009 and 2010) and a data warehouse containing dat…

  Jasmine.a.ferns

  1 replies

  14 years, 7 months ago

  By: happycat59

• Rusty MDX / Cube Calc

  Hi, This has been driving me nuts for the best part of an hour.. please help, my MDX is clearly far…

  BGM

  3 replies

  14 years, 7 months ago

  By: BGM