Analysis Services

• Topics

  Started by

  Posts

  Last post

• Date Difference of current record and its relative record using MDX

  Dear All, I have a some rows where it points to another row in same table based on RelativeId colum…

  LearnTSQL

  0 replies

  1 year, 4 months ago

  By: LearnTSQL

• Can workspace database be recreated in tabular cube?

  Hi All, I need to modify an old tabular model for which workspace database has been deleted acciden…

  kirti

  1 replies

  1 year, 5 months ago

  By: Martin Schoombee

• Collect data from multiple similar tables and append - PowerQuery/PowerBI

  I'm trying to do something similar to using a folder source for data - basically where I specify a …

  pietlinden

  1 replies

  1 year, 5 months ago

  By: pietlinden

• How to display data in SSAS by start and end date

  I have a SQL Server 2016 OLAP Cube in the multidimensional mode and a corresponding database contai…

  StevenM

  1 replies

  1 year, 6 months ago

  By: StevenM

• how to make cube choose certain fact table by default

  I have 2 identical fact tables: Fact 1: linked to datetime dimensnion Fact 2: is not  linked to da…

  Sezam

  2 replies

  1 year, 6 months ago

  By: Sezam

• How can I show the last opening period for each project in my project dimension

  I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date Project …

  casagrandi

  1 replies

  1 year, 7 months ago

  By: casagrandi

• How can external customers access SSAS cubes to create their own analysis

  My company has a number of SSAS tabular cubes which are deployed to a server and Power BI reports a…

  Bhagat

  2 replies

  1 year, 7 months ago

  By: EdVassie

• using PowerQuery with SSAS Tabular

  I have a stupid question... I can do all the PowerQuery stuff in PowerBI, but can I move those tran…

  pietlinden

  1 replies

  1 year, 7 months ago

  By: pietlinden

• how to get previous value in a fact table for a measure in mdx

  Hello Guys! I want to write an mdx query with a calculated Measure. Here is my fact table: How to …

  casagrandi

  1 replies

  1 year, 8 months ago

  By: casagrandi

• SSAS tabular: question about Profiler event

  Hello, We are working with a SSAS tabular model in compatibility level 1500 on an SQL 2019 environm…

  woutgoet

  3 replies

  1 year, 10 months ago

  By: woutgoet

• Run MDX Query against different Databases on the same server

  Ahoy, i have few ssas server instances and many tabular models on each of the server. Now i want to…

  ktflash

  1 replies

  1 year, 11 months ago

  By: ktflash

• Visual studio, SSAS and stored procedure

  I am trying to get data from a stored procedure into my SSAS Tabular model project. This stored pro…

  don075

  2 replies

  1 year, 11 months ago

  By: don075

• Visual Studio and SSAS

  I have a question regarding Visual Studio and SSAS. I created a "Analysis Services Tabular Project"…

  don075

  1 replies

  2 years ago

  By: don075

• SSAS Tabular Excel reports slower after upgrade

  Hello, We recently upgraded our SSAS Tabular model from compatibility level SQL Server 2014 (1103) …

  woutgoet

  4 replies

  2 years ago

  By: woutgoet

• Dynamically select tables for SSAS processing

  Hello Folks, Analysis Server 15.0.35.22 I am currently processing my full database via SQL Server A…

  Chrissy321

  3 replies

  2 years ago

  By: Chrissy321