Analysis Services

• Topics

  Started by

  Posts

  Last post

• Non Existing Dimension Records for Rolling 12 Months Calculations- DAX Query.

  HI , I have a dimension Vendor and for this vendor i do not have any Sales Record for 2 Particular …

  Steve Dell

  1 replies

  2 hours, 30 minutes ago

  By: Martin Schoombee

• DAX not Calculating Rolling Total Correctly

  When Attempting to calculate a rolling total with the following DAX Formula Delta12M2:= CALCULATE( …

  Steven.Grzybowski

  1 replies

  1 day, 1 hour ago

  By: Martin Schoombee

• Create a calculated member in a tabular model

  Hello All, I am trying to add a calculated member in a dimension. In Multidimensional model, I do t…

  Lidou123

  3 replies

  1 day, 22 hours ago

  By: Martin Schoombee

• Where are the MSAS performance objects in SSAS 2017?

  Greetings! I opened Performance Monitor on a machine running, among other SQL services, SSAS 2017. …

  SQLPadawan

  1 replies

  2 days, 15 hours ago

  By: Sue_H

• All fact dimensions in a measure group must be roles of the same database dimens

  I have developed a Cube and i needed to add anew dimension. It gives me error below. I’m doin…

  yrstruly

  1 replies

  3 days, 3 hours ago

  By: yrstruly

• Dimension [Fact Internet Sales] : Create hierarchies in non-parent chi

  Hi, Please Assist? I am trying to deploy a cube and it gives me a few errors. How do i correct? I a…

  yrstruly

  10 replies

  3 days, 23 hours ago

  By: Matthew Cushing

• SSAS Tabular Model Row Level Security with Excel, PowerBI and SSRS

  I am working on a solution where the data is coming from a SSAS tabular model and I am looking to i…

  LostHighway72

  0 replies

  1 week ago

  By: LostHighway72

• The requested security protocol is not supported.

  Hi Experts, I am working on SSRS server and i have a report that is dependant to a cube.The report …

  tmmutsetse

  0 replies

  2 weeks, 2 days ago

  By: tmmutsetse

• SSAS Cube (Multidimensional) Processing hangs / gets stuck after DB CL change

  Today, after I changed the relational database that feeds the cube from compatibility level 10…

  Ransonian

  3 replies

  3 weeks, 3 days ago

  By: frederico_fonseca

• SSAS users randomly losing connection

  Hi all We’ve got 5 multidimensional cubes and access is granted by AD groups.There is one rol…

  richardmgreen1

  9 replies

  1 month, 1 week ago

  By: richardmgreen1

• Tabular Model -Convert MDX to DAX query in Calculations

  Hi < I am converting Multidimensional Cubes to Tabular Model in SSAS. I need to conver…

  Steve Dell

  1 replies

  1 month, 1 week ago

  By: Brian Carlson

• Writeback Values bigger than Int allows?

  Ahoi, i have a write Table enabled and fully functionally working, the only issue is my users need …

  ktflash

  2 replies

  2 months, 2 weeks ago

  By: Steve Jones – SSC Editor

• Cube switching

  Hi all We’ve been looking at schema switching to minimise downtime for users (and it’s …

  richardmgreen1

  5 replies

  2 months, 3 weeks ago

  By: richardmgreen1

• Performance issue in SSAS tabular

  Hi all; I’ve created an SSAS tabular model based off of sales facts recorded at the invoice l…

  jason.millar

  1 replies

  2 months, 3 weeks ago

  By: Brian Carlson

• How do I friggin’ connect to SSAS via SSMS? (cryptic errors galore)

  Hi there —I’m trying to connect to an SSAS server via SSMS (the preferred client I̵…

  peter_parker

  7 replies

  3 months ago

  By: Martin Schoombee