So this question goes off the one here
I've been trying to do a similar count measure and I did the suggested solution but it's still running.... and it's been more than 30 minutes with no results, ...

I need to display the YTD value for a measure (e.g. Written Premium) for the current year and prior year, but only up to the month of the current year that has data. For example, this is May, 2020, ...

I do not understand why I do not get the same result between these 2 codes below :
I have a date dimension with a year attribute composed of members: 2016, 2017, 2018 and 2019
Code 1 :
with
Member [...

I have an SSAS Tabular Cube, which I refresh daily. It's big and not efficient for some use-cases. I want to create a sub-cube with filtered data and deploy it as a separate cube. How should I do it?
...

I have a fact table that is linked to a dimension table( customer ), and in this table I have a column( measureA )
In my SSAS I have two measures: MaxMeasureA( max value os measureA ), and MinMeasureA(...

I have SQL server database with Always Encryption enabled in some of table columns in database. By specifying Column Encryption Setting = Enabled property in the SQL connection instance I was able to ...

I'm using JDB4OLAP for a project , in order to connect SAP BW OLAP using an ETL Engine.
I try to make a query , but I don't find the way to get the uniquename of a dimension value.
Do you know if is ...

I want active employee head count.This is my sql query and counting result is ok by this query.But i need this result from ssas cube.I don't know exactly how to write dynamic calculative measure for ...

I have an SSAS cube with a FactTicket, that has a TicketsSold measure.
The cube has a good number of dimensions. Lets call them Date, Agent and Geo.
I can create a table (we're using Power BI service, ...

I am using MDX query designer in PowerPivot to drag the data as well as to create calculated columns.
I want to combine two fields:
one shows one side of accounting account, another opposite side of ...

In Dax Studio, I am able to create an OLEDB connection String to an Excel Power Pivot Data Model by adding Cube=Model to the OLEDB connection string. This allows session-scoped items in MDX queries ...

I have never been any official documentation from Microsoft on the full PivotTable.PivotSelect name parameter syntax. Below is my best understanding. Are there additional details not included below?
...

I have a SSAS multidimensional cube and i am trying to calculate a denominator for a query by using a scope statement.
I am trying to assign the measure "Total SalesCumulative" the total value of all ...

I have a dimension that consists of members with the following format 100 - Sales, 200 - Purchase etc. What I wish to do, is to substring starting from the left and remove everyting after the first ...

Item Sales two weeks or n weeks before/after item was first received ##
I would like to see the sales in for example 2 weeks after an item was first received, 4 weeks after received etc.
I think once ...

I am using the adodbapi python library to query an SSAS Cube. Essentially, my goal is to ask the user to first input the Account Id. Then, I would like that to be passed as a parameter dynamically in ...

This might be a longshot, but maybe there is an ssas/mdx guru here that has stumpled upon the same problem regarding aggregated calculations and leap years. So what I am trying to do, is to create a ...

I am trying to create a query but it utilizes two different dimensions. I receive this error "Members, tuples, or sets must use the same hierarchies in the function." I've run this with/without the ...