I am encountering a problem quite frequently in a console application (.NET Framework 4.7.2) that attempts to build and then deploy a Tabular Database to a Power BI workspace as a Semantic Model. W...

I'm really new to this, so I am probably making a simple mistake. I need to make an OLAP cube using a remote database. After I set up the dimensions and measures and create the cube, I can not get...

This feels like a really basic question, because it's a really basic function I'm looking for. I know you can do this: ([Dimension].CurrentMember IS [Dimension].[AParticularMember]) and you get...

Microsoft says: https://learn.microsoft.com/en-us/analysis-services/instances/connection-string-properties-analysis-services?view=asallproducts-allversions "When connecting over TCP to SSAS, t...

Set up: Similar to this question on a MSDN forum, I have a measure that switches between various other measures (some of them much more complex than others). The measure looks like this (my actual ...

I am using Analysis services in Microsoft SQL Server 2012 on Windows 7. I tried to create Mining models and process it. I am getting the following error while processing it. OLE DB error: OLE D...

How do I resolve this issue with requests to msmdpump.dll for connections to SQL Server Analysis Services? I am receiving a 500 Error from the IsapiModule. On a Windows Server 2012 R2 machine, wit...

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter. Building the same thing in SSAS Tabula...

I need to update the compatibility level of the Azure SSAS Model to 1400. It's currently in 1200. When I click on Model.bim and go to Properties. (Inside Visual Studio 2017) There is no option to s...

I am looking at ADOMD nuget package. It seems it does not support ASP.NET Core framework. How can I Get this nuget package for ASP.NET core. If not this package, do we have any other alternative to...

I have a tabular database in SSAS 2019, where the data source is SQL Server 2019. I need to retrieve data through XMLA, so I followed these instructions to connect IIS to SSAS. When I send a SOAP ...

I am mew to DAX. How can I concatenate three different columns say First_Name, Middle_Name and Last_Name to a single column with a space in between using CONCATENATE function in DAX. At present I ...

I have installed SSAS and created a project. After two months working with seas, now when creating a new project, the analysis service is not available. but I can open old SSAS projects. How I can ...

I have some attributes that I am using to build hierarchies....(go figure).....after these attributes have been included in the hierarchy due to the change that I have made in their key columns the...

I'm looking at the datekey column from the fact tables in AdventureWorksDW and they're all of type int. Is there a reason for this and not of type date? I understand that creating a clustered ind...

I have following problem: When I try to deploy my SSAS project (with cube, dimensions and all that jazz) to sql-server, it throws error saying that You cannot deploy the model because the DB de...

I have a cube which has few big dimensions. It is currently taking 2 hours to Process Full. I have now partitioned the cube and followed below strategy: Process Update dimensions Process data Par...

I need to your help to change the dimension attribute data type in Excel sheet when connecting cube via excel and I have defined a column as "FLOAT" in Data warehouse and "DOUBLE" in Cube,but that ...

I am using PowerBI Desktop/Service as a Front-End and Analysis Services Multidimensional as Back-End. I want to create a complex calculated member but I have a problem in some part of the member. ...

I have the following Import-Module SqlServer $Analysis_Server = New-Object Microsoft.AnalysisServices.Server $Analysis_Server.connect("$server") $estimatedSize = $([math]::Round($($($Analysis_S...

Has anyone seen this error before? If so, how did you fix it? I can't find anything on Google. Here is what I have done: I tried doing a Google search but practically nothing came up. I checked ...

I am building a multidimensional cube using SSAS, I created the partitions based on a date column, and defined a partition for each day. Source data size is bigger than 2 TB. While deploying and p...

I have a dimension called [Band] and it can have several different values: [Band].&[A]&[Under $400] [Band].&[B]&[$400 - $1,000] [Band].&[C]&[$1,000 - $2,500] [Band].&[D...

The properties panel in SSDS for a Measure Group has two properties I'd like to learn more about: EstimatedRows and EstimatedSize. There seems to be little documentation on either of these. I did ...

A user trying to check the Sales Amount per Salesperson. Sample data: Salesperson Sales Amount 001 1000 002 500 003 750 Grand Total: 2250 It looks fine, but we have the following hierarchy Co...