20 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,270 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow 80 Reputation points
0 answers

Modelos tabulares no liberan memoria

Buenos dias, paso a consultar por un problema. Tengo varios modelos tabulares, y cada vez que proceso alguna partición, la memoria de mi servidor llega a 85/90%. Una vez terminado el procesamiento, la memoria queda en esos niveles, por lo que si quiero…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2024-05-17T11:56:15.51+00:00
Roberto Lavisse 0 Reputation points
0 answers

Inquiry Regarding Missing redist.txt File for Package "Microsoft.AnalysisServices.NetCore.retail.amd64"

Dear Microsoft Q&A Team, I hope this message finds you well. I am currently working with the "Microsoft.AnalysisServices.NetCore.retail.amd64" package, and I have a question regarding the distribution rights outlined in the nuget.org…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,360 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2023-11-15T10:11:01.9566667+00:00
Kondapalakala, Shanmukha 5 Reputation points
edited the question 2023-12-06T13:01:17.7+00:00
Kondapalakala, Shanmukha 5 Reputation points
0 answers

How to create an average, rank, total measures over a field (by dynamic period) in SSAS?

Hi everyone, (I post here a question I created in stackoverflow, hopefully I will have better luck here) I'm new with SSAS technology and I have an existing cube that measures hits by page on web site. In few words the cube is structured as followed: a…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2023-10-05T08:27:57.2966667+00:00
Lanz 0 Reputation points
0 answers

What version of SSAS support the DAX expressions FIRSTNONBLANKVALUE and LASTNONBLANKVALUE

I am using SSAS 15.0.32.50 and I used FIRSTNONBLANKVALUE and LASTNONBLANKVALUE DAX expressions in my measures. The model gets deployed without an issue but when I try to use these measures I get an error "Expression: Failed to resolve name…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2023-09-13T14:22:23.0533333+00:00
Subash Basnayake 61 Reputation points
0 answers

Problem In Accessing Linked Server to SSAS

I have created a Linked Server to SSAS (tabular) from My SQL Server Without a Catalog Name. I Expect to See all the Data Models and their Tables. However, I only see the tables related to One DM and all other Data model just shows up without any table.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,270 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2023-08-26T00:14:22.8833333+00:00
swabhiman das 20 Reputation points
edited the question 2023-08-26T06:45:49.66+00:00
swabhiman das 20 Reputation points
0 answers

Cannot run SQL Agent Analysis service command against server alias

Hi, I seem to have everything working except running a SSAS Tabular cube refresh from SQL server based on a ALIAS name. SQL Server 2019, DNS & SQL Server alias configured to use CubesDEV alias. First test, connected with SSMS support SupportDEV…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2023-05-17T13:37:41.17+00:00
Arjan Fraaij 0 Reputation points
edited the question 2023-05-17T13:39:52.4133333+00:00
Arjan Fraaij 0 Reputation points
0 answers

IIS 禁止加载 aspnetcore-browser-refresh.js

IIS 禁止加载 aspnetcore-browser-refresh.js

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2023-04-05T05:08:11.8366667+00:00
xin chen 0 Reputation points
0 answers

SSAS extremely slow after RLS implementation

I have an SSAS that is consumed by some users using Powerbi and excel. Its being used and works perfectly; but now, I have introduced some RLS security and for people accessing with limited permissions, it is awfully slow... How can I troubleshoot this?…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2023-01-31T10:11:57.6+00:00
ovonemty 56 Reputation points
0 answers

crazy response from studio

I do query it is supposed to give me top ten producers over several past months trending of premium of course the ideal way is to do months on columns and producers on rows and premium in cells but if I move measures.wp to where clause and…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-12-09T09:51:45.74+00:00
greg lipman 61 Reputation points
0 answers

SSAS MDX measure values ratio

Hello, i need to find ratio between good Plans and bad and i cant get the ratio working i need it to be in the subTotals/grandTotals --- ---- this is to find Realiability Status, this is working CREATE MEMBER CURRENTCUBE.[Measures].[Plan…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-12-07T08:23:11.157+00:00
Ramūnas Lukošius 1 Reputation point
0 answers

Server returned HTTP response code: 413 for <scrubbed secret> from msmdpump.dll

Getting error while retrieving data from Analysis Services. I tied to adjust below config. properties but it doesn't help. maxRequestEntityAllowed uploadReadAheadSize maxAllowedContentLength maxRequestLength Is there any other…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-09-22T20:37:46.707+00:00
Shaharyar Mahmood 21 Reputation points
0 answers

Server Internal error: An unexpected exception occured in MDX Query

Hello everybody, maybe i can find help here for my MDX Problem. When i run an MDX Query using Functions like "Space()" or "Format()" i get an Error Message: "Server Internal error: An unexpected exception occured." here…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-09-02T13:27:16.957+00:00
Sebastian Borchert 6 Reputation points
0 answers

Powershell with multidimensional and tabular ssas instances

Hi All! I've got two SSAS instances, one with multidimensional databases (#1) and one with a tabular model (#2). I have stopped the multidimensional instance (#1) because we do not need it any more. When I try to connect via powershell to sqlas …

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,449 questions
asked 2022-08-16T09:30:31.007+00:00
Christoph Muthmann 181 Reputation points
0 answers

Is it possible to run an azure load test via jmeter script to test query response times from Azure Database for PostgreSQL flexible server.

I tested my jmeter 5.5 script on my workstation to ensure it worked ok. I then set up an Azure load test and uploaded my jmeter script but when I run the test it fails but no information on why(downloaded worker log but no information on failure). …

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-08-03T22:49:05.717+00:00
Agnew, Ciaran (Ciaran) 1 Reputation point
0 answers

Automating SSAS Multidimensional partition, best way to get new definitions back to source control?

I am working on a SSIS script task to automate the creation of a monthly partition to reduce the processing time using AMO. This looks like its all great, other than the definitions will not be contained in the project. So far the only thing I…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-06-13T11:08:06.657+00:00
Jon Joseph 1 Reputation point
0 answers

Recieved Error Payload From Gateway Error

When trying to process a table in SSAS tabular cube it is failing with below error. Rest of the tables are getting processed without any issue. Only difference is, this particular table more rows compared to other. Failed to save modifications to…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-06-09T13:56:29.493+00:00
Roja Makkena 1 Reputation point
0 answers

How to display DB data in excel (Cube x Tabular)

Hello, I would like to ask for a direction. I got a request to enable our finance people to work with data in excel. I thought I could build up a Cube or the Tabular model, but my goal would be to allow the users to display lots of detail. So we…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-06-07T11:11:19.347+00:00
Jaroslav Cupak 1 Reputation point
0 answers

exclude msprop:design-time-name at comparison [workaround]

Hello, I opened a thread some times ago on MSDN Forum "exclude msprop:design-time-name at comparison" that was Archived. The solution suggested there was to use BIDS Helper SmartDiff. Today I found another workaround, after downloading a…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2022-03-30T12:48:54.533+00:00
Clement Ratel 1 Reputation point
0 answers

Approaches to create dynamic partition & process for SSAS without using SSIS its possible.

Scenario is below: I have SSAS multidimensional cube. Need to create partitions dynamically for each quarter and should process only current quarter data. Gone through many searches can see using SSIS tool with using AMO or store procedures using…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
asked 2021-07-01T10:15:33.24+00:00
bhavani uppala 1 Reputation point