Analysis Services

• Topics

  Started by

  Posts

  Last post

• 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

  1 week, 4 days 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

  2 weeks, 3 days 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

  3 weeks, 5 days 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

  1 month, 1 week 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

  1 month, 1 week 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

  1 month, 2 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

  1 month, 3 weeks 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

  2 months, 2 weeks 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

  3 months, 1 week ago

  By: Test User

• Table.NestedJoin in Azure Analysis Services

  We have an M/Power Query query in Power BI that uses Table.NestedJoin. However, we get errors when …

  imani_technology

  1 replies

  3 months, 2 weeks ago

  By: imani_technology

• Import a PBIX file into Azure Analysis Services

  I want to import a Power BI PBIX file into Azure Analysis Services. I don't see any recent informat…

  imani_technology

  4 replies

  3 months, 3 weeks ago

  By: imani_technology

• Where is the AdventureWorks 2008R2 Analysis Services project download?

  I need the 2008R2 version because I want to climb the Stairway to MDX and in Level 1 it says: Consi…

  Test User

  8 replies

  4 months ago

  By: Test User

• The 'Tabular View' feature is not included in the '64 Bit Standard' edition of

  Hi , I am getting the error below when i want to process the cube.Please help me if anyone came acr…

  tmmutsetse

  3 replies

  4 months, 1 week ago

  By: Paul Hough

• OLAPQueryLog does not work for SSAS Tabular mode

  I running into a problem when I try to setup querylog in SSAS. The QueryLog Table name has been cre…

  Tho Le

  1 replies

  4 months, 2 weeks ago

  By: Tho Le

• Only 90 Days of Data in Azure Analysis Services

  I want to make sure there are only 90 days of data in my Azure Analysis Services (AAS) model. I'm t…

  imani_technology

  1 replies

  4 months, 3 weeks ago

  By: imani_technology