SSAS connections are not happening through msmdpump.dll while doing the load tests. What to do?
Hi All, We are performing a 1 hour load test of 300 users and 370 users on SSAS and we are seeing that application is working fine under 300 user load. However, when we are conducting 370 users test, in the first 20 minutes CPU was getting occupied 100%…
Runing SSAS Tabular Processing Script (TMSL) from SSAS Database Engine
Hello Experts, In continuation of my previous question https://learn.microsoft.com/en-us/answers/questions/2076521/processing-monthly-partition-from-sql-job-using-st?source=docs We have SSAS Tabular model database and SSAS Database engine. When trying to…
The workspace database server localhost is not found ( SSAS PROJECT)
Good evening everyone :) I Developed an SSAS project through visual studio. Every thing worked fine but today while trying to open the project but I had this error message: "Error in Visual Studio: You cannot open the IBM file. The workspace…
OLAP Cube refresh fail on re-opening
Hi all We have an Excel pivot that is connected to an OLAP Cube using msmdpump and basic authentication. When we create the connection it works fine, but as soon as the workbook is saved and re-opened, we are unable to interact with the pivot or…
Date Fields Appearing as Text and Not Grouping Properly in Excel Filters (SSAS Tabular Model)
We are experiencing an issue with our SSAS Tabular model where fields defined as "Date" are being recognized as "Text" when connected to via Excel. This behavior impacts the ability to use Excel's date functionalities, such as…
Analysis Service very slow to connect in SQL Management Studio
Hi all, I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC. Connecting to the SQL Database Engine in SSMS is very fast. However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost…
I have installed Microsoft SQL Server 2022, but I cannot see the SSIS & SSAS packages.
Good day! When I installed SQL Server, I remember having ticked the options that asked me whether I wanted to include SSAS, SSIS & SSRS; I ticked them all since I wanted to have a many features as I possibly could. Now, am studying the book below: I…
Prevent access from excel
I am looking to prevent access from Excel to my SSAS... I have 10 cubes, and several PowerBI that consume from it... But I have some users that connect from excel and I want to prohibit that access. How can I prevent people accessing from excel?
SQL Server agent job that processes SSAS database gets warning 1092091904
Message Executed as user: xxxxxx. <return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Messages…
Testing migration of SQL/SSAS from 2017 to 2019, when editing an SSAS database connection in SSMS 18.12.1 results in an error - Object reference not set to an instance of an object. (Microsoft.AnalysisServices.SsmsManagementDialogs)
After updating connection string properties, SSMS returns TITLE: Microsoft SQL Server Management Studio ------------------------------ Object reference not set to an instance of an object. (Microsoft.AnalysisServices.SsmsManagementDialogs) …
Deselecting Members In An Excel PivotTable Leads To Missing Rows version 2
Dear community, I followed the steps from this guide…
Processing monthly Partition from SQL Job using Stored Procedure
Hello Expert, I have a Tabular model which is having a fact table partitioned monthly on date field. e,g. Partition_July2024, Partition_Aug_2024, Partiton_Sept2024 etc.. I want to create a single SQL job to process these monthly partitions which should…
how to get max min date from a tuple
suppose i have a bunch of people (with dimension) they have a bunch of claims (dimension) and in each claim there is a bunch of records with amount and date! those records/transactions form a cube with measures like amounts paid Ultimately i need to get…
PivotTable in Excel
Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…
I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.
I got an error that I cannot connect to SQL while demoing olap. I cannot connect to SQL and it asks me to enter "user id" and "password"
SSAS - TMSL Query and Monthly Partition , how to add Filter
Hello Experts, Trust you are all are doing good. Having following environments, one SQL server for DWH and another Enterprise Edition of SSAS hosting Tabular model(TM). DWH design is Star Schema based, where the fact table would receive roughly 1 million…
SSAS : How to fix An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize')
Hi I have XMLA script to create the Analysis service database. Ii try to deploying the script. I'm facing an issue while running the script - Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function…
getting error while connecting ssms for analysis services
Hi, Unable to connect Analysis Services (SSAS) with Server Name in SSMS. Please help me in this regard
microsoft analysis services projects download but not showing in Download Folder
Hi, Hope everyone is doing well. When I trying to download and install Microsoft Analysis Service (SSAS) from Visual Studio. I am not able to see in download folder after downloading the software. How can I Instal SSAS? I have already SSIS in my system.
IDbConnection error on process SASS database caused by Windows updates
Hello, At some point, our developer instance of Analysis Services started to give an error: Errors in the high-level relational engine. . The exception was raised by the IDbConnection interface. It does not contain any on what is wrong with it. It…