Analysis Services

• Topics

  Started by

  Posts

  Last post

• SSAS model isnt displaying any data

  Dear Everyone I received a SSAS package from the developer and when i try to open it the first erro…

  hurricaneDBA

  1 replies

  4 weeks, 1 day ago

  By: hurricaneDBA

• Changing SSAS TCP port directly in config file

  Goodday, I have a problem with changing the TCP port for SQL Server Analysis Services by using the …

  Marco

  2 replies

  2 months ago

  By: Marco

• Empty Table after model full refresh

  Hello, I have a problem. We have a SSAS Tabular model which is scheduled to be refreshed daily (wit…

  Mart

  2 replies

  2 months ago

  By: wi11iamr

• Azure Analysis Services Memory Usage

  Hi there. I'm trying to identify what users or processes/queries are consuming the cube server memo…

  djbuncle

  2 replies

  2 months, 1 week ago

  By: donald.parish

• Min of LastNonEmpty values

  I everybody, I'am currently fighting with Mdx in a cube about the active directory. In simple words…

  Donpi

  1 replies

  2 months, 2 weeks ago

  By: Donpi

• Floor Function in MDX

  Hi All, Is there any function like Floor function in MDX. Ex: 1) value is 1.9 then output is 1 …

  narendra.babu57

  2 replies

  3 months ago

  By: JonsDorh

• Convert sql query to MDX

  I want to find an mdx equivalent of this query: Select a.shopId , Month(TransactionDate) Month_Tra…

  Ninjahat

  1 replies

  3 months, 3 weeks ago

  By: Ninjahat

• Visual Studio in SSAS tabular mode is extremely slow

  I am creating a SSAS tabular model project in Visual Studio 2012 with SQL Server Data Tool. If I ad…

  SQL Guy 1

  5 replies

  4 months ago

  By: cs.menni

• Disappointed by new Object Level permissions in SSAS 1400 / 2017

  I need to build / implement a tabular model in SSAS where users can execute / browse reports in Pow…

  djb_77v

  4 replies

  4 months, 1 week ago

  By: mrxindowntown

• SSAS Tabular SSDT DAX Drillthrough Issue

  Hello, I've come across a scenario where the drillthrough functionality is not working when multipl…

  Costas_C

  3 replies

  4 months, 3 weeks ago

  By: Martin Schoombee

• DAX how to rewrite this FILTER to CALCULATETABLE?

  Ahoi,   i have been starting to look into DAX and there is something i could not find an answe…

  ktflash

  3 replies

  4 months, 3 weeks ago

  By: Martin Schoombee

• Issues with multiple SSAS tabular instances on same server

  I have created a second instance of a tabular server on the same server but I am having issues proc…

  rnguyen11

  1 replies

  4 months, 4 weeks ago

  By: rnguyen11

• Dimension key problem

  Hi, I need to modify an existing dimension that calculates that how late (how many days) shipments …

  arto.kilponen@kapsi.fi

  1 replies

  5 months, 1 week ago

  By: arto.kilponen@kapsi.fi

• Errors in the OLAP storage engine: An error occurred while processing the '<xxx>' partition of the '<xxx>' measure group for the '<xxx>' cube from the <xxx> database."

  Hi all, Can anyone please advise how to troubleshoot this error? The job has been running fine in …

  newbie01.sqlserver

  3 replies

  6 months ago

  By: fcoastu

• SSAS Dimension Wizard - name column list missing

  I tried to carry out out the instructions in the paragraph entitled "Defining the Internet Sales Or…

  Test User

  2 replies

  6 months, 3 weeks ago

  By: Test User