1,245 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
2 answers

Visual Studio 2019 (SSAS) - Error when trying to open my model

The backstory: I work with SSAS and a tabular model via a VDI. The connection with my VDI went wonky and now there is a disconnect involving my tabular model. I'm only trying to open my tabular model (.bim) via SSAS, and I keep getting the error that…

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,245 questions
asked 2022-08-17T22:03:59.19+00:00
Tanner Yatsko 11 Reputation points
commented 2024-01-04T21:21:38.0866667+00:00
Dmitrijs Pilāts 0 Reputation points
2 answers

Tabular Model processing a calculated table (recalc)

I have a calculated table in my SSAS Tabular Model which is getting data load using a dax script. when we are checking the data using evaluate tablename' in ssms , I am getting errror like- table need to be processed or recalc. When we are processing…

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,245 questions
asked 2022-11-11T12:31:36.253+00:00
Avhilash Kumar 21 Reputation points
commented 2024-01-02T22:47:41.4733333+00:00
Ricardo Silva 6 Reputation points
2 answers One of the answers was accepted by the question author.

SSAS Connect Problem

I have trouble connecting to SSAS, is there any documentation I can learn? Thanks!

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,245 questions
asked 2023-12-29T02:48:44.39+00:00
kl 20 Reputation points
accepted 2023-12-29T09:48:35.7866667+00:00
kl 20 Reputation points
2 answers

Week dimension in case of month split

Hello! For example In year 2024 week 9 splits into two months PK_Date Month Month_Of_Year Week Week_Name Week_Of_Year 2024-02-26 00:00:00.000 2024-02-01 00:00:00.000 2 2024-02-26 00:00:00.000 vko.9 9 2024-02-27 00:00:00.000 2024-02-01…

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,245 questions
asked 2023-12-22T11:13:40.0366667+00:00
Pekka Niemi 0 Reputation points
answered 2023-12-28T12:28:34.1233333+00:00
Pekka Niemi 0 Reputation points
0 answers

Visual Studio 2019 Community crashes (BI Add-ins) Version 16.11.26

Hi People, To start I did a clean install again of VS 2019 Community edition version 16.11.26 because of this issue. Installed Extensions are: Microsoft Analysis Services Projects 2.9.18 SQL Server Integration Services Projects 4.4 There is an…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,614 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,245 questions
asked 2023-04-22T08:26:12.1433333+00:00
Arjan Fraaij 0 Reputation points
commented 2023-12-28T09:45:00.98+00:00
Tianyu Sun-MSFT 27,271 Reputation points Microsoft Vendor
1 answer

Custom Grouping in a tabular model

Hi all, Today we have a non tabular cube that we analyze by creating custom groups inside of an excel pivot. For example, using the current period (YYYYMM), we look at financial activity for a current period (ex: 202311), all prior months (202310 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,245 questions
asked 2023-12-27T19:40:32.82+00:00
db 21 Reputation points
answered 2023-12-28T06:58:03.2+00:00
Alexei Stoyanovsky 3,416 Reputation points
2 answers

Install SQL reporting service

I have a SQL 2016 enterprise server , want to re-install report service , running on windows server 2016 . I have downloaded SQL reporting service 2022 and installed it , it pops to ask install evaluation , developer or express edition , I lost the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,801 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,245 questions
asked 2023-12-12T04:42:27.29+00:00
derek chan 1 Reputation point
commented 2023-12-20T08:27:48.1566667+00:00
AniyaTang-MSFT 12,316 Reputation points Microsoft Vendor
2 answers

Upgrade SQL Server 2019 (Standard Edition) to SQL Server 2022 (Standard Edition)

I want to upgrade my production SQL Server (2019 Standard Edition) version to SQL Server 2022(Standard Edition) which is hosted on the Azure virtual machine. There are 400-500 databases currently running on the SQL server 2019. So also want to migrate…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,801 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 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,245 questions
asked 2023-12-13T15:08:07.2733333+00:00
kanav sharma 5 Reputation points
commented 2023-12-20T08:24:17.2733333+00:00
AniyaTang-MSFT 12,316 Reputation points Microsoft Vendor
0 answers

getting an error when connecting to SSAS multidimensional cube from excel, but no error from SSMS or Power BI.

Data connection from Excel to SSAS Multidimensional cube is getting an error message: "Data could not be retrieved from the database. Check the database server or contact your administrator. Make sure the external database is available, and then…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,467 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,245 questions
asked 2023-10-03T13:12:34.58+00:00
Torrey Lindemann 10 Reputation points
commented 2023-12-15T12:39:31.1566667+00:00
Peter Bobrowski 5 Reputation points
3 answers

Analysis Services 2022 Tabular Model error

When run query in SSMS in { "create": { "database": { "name": "AdventureworksDW2016", "description": "test" } } } i have error: Executing the…

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,245 questions
asked 2023-06-20T11:58:36.2333333+00:00
Omiński Tomasz 25 Reputation points
commented 2023-12-08T13:31:31.4766667+00:00
SK 0 Reputation points
1 answer

How to fix ---- Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').

i have XMLA script to create the Analysis service database. i try to deploying the script with both primary and secondary server in the AAG environment. i'm facing an issue while running the script - Internal error: An unexpected error occurred (file…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 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,245 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
958 questions
asked 2023-08-22T09:45:15.17+00:00
Kaviyarasan J 5 Reputation points
commented 2023-12-07T20:58:39.7+00:00
SK 0 Reputation points
2 answers

How to complete offline installation of machine learning server components

Hi, I'm trying to install SQL Server 2019 for a course I'm taking and cannot get past the installation process. I keep getting stopped by offline installation error. hyperlinks are provided but i am unable to click or copy them. I'm supposed to create a…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 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,245 questions
asked 2023-12-07T01:51:43.9666667+00:00
Lawrence Moskal 0 Reputation points
edited the question 2023-12-07T09:52:56.5933333+00:00
romungi-MSFT 42,191 Reputation points Microsoft Employee
1 answer

while processing Analysis service database XMLA script via SQL server agent ,received the Timeout error.

Microsoft.AnalysisServices.Xmla.ConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. --->…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 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,245 questions
asked 2023-11-30T15:19:22.86+00:00
Kaviyarasan J 5 Reputation points
commented 2023-12-07T08:53:30.3633333+00:00
Kaviyarasan J 5 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,176 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,245 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
4 answers

how to reverse comma seprated values.

hi, i have coma separated vales in a table. what i want to reverse it like 'CLP,CAD,GBP' pls tell me how it can be done with out using xml in efficent way. DECLARE @TBL AS TABLE (COLUMN1 NVARCHAR(100)) INSERT INTO @TBL SELECT…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,801 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,245 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2023-11-10T10:25:24.18+00:00
Rajesh Kumar Yadav 1 Reputation point
commented 2023-11-30T02:48:42.2333333+00:00
CosmogHong-MSFT 23,166 Reputation points Microsoft Vendor
1 answer

More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec. Activity ID: eff809b2-03ac-4706-9813-3b96db326c2c Correlation ID: 2d661bae-a418-9231-d2b1-a2fb9cd0c806 Request ID: 474226a5-7911-456b-a636-889fb02a3cc6 T

Hi, Please explain why i am getting the below error when i used a slicer member ID which has 1M records is there any solution for this? More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec. Activity…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 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,245 questions
asked 2023-11-29T06:45:15.4533333+00:00
Badugu,Jagadeeswari 0 Reputation points
answered 2023-11-29T07:15:06.2866667+00:00
PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
1 answer

MDX Cube Hierarchy is behaving from Tabular Cube

Capture.PNG Cube is available in both MDX and tabular formats. The company wants whatever tabular template is available to be incorporated into the mdx version of the cube. However, there are some differences in behavior between MDX and Tabular. Please…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 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,245 questions
asked 2023-11-23T15:28:52.82+00:00
Prabu, Chandran 41 Reputation points
commented 2023-11-27T08:29:31.2466667+00:00
PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
4 answers

processing dimensions in SSAS 2019 takes ten times longer than in SSAS 2017

We are currently observing a significant time difference when processing dimensions in SSAS 2019. Each one of them takes about ten times longer to process and we are unable to find a good reason for it. To test this we've build the following setup: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 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,245 questions
asked 2022-01-21T10:54:14.59+00:00
Holger Kühn 1 Reputation point
answered 2023-11-24T16:19:28.5366667+00:00
Patrick Taylor 0 Reputation points
1 answer

Equality of UI input elements vs. database table entities

As you can see in the following image, the user interface of my app has a total of 12 text boxes (6 text boxes in each part) in the seller and buyer sections. The image below is a part of the ERD relating to this application's database; since the…

Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,674 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 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,245 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,264 questions
asked 2023-11-17T19:08:39.74+00:00
Reza Jaferi 331 Reputation points
commented 2023-11-21T19:29:30.5466667+00:00
Bruce (SqlWork.com) 56,526 Reputation points
1 answer One of the answers was accepted by the question author.

Why won't the Day function reference my dates column in Power BI?

I am trying to run a DAX calculation to clean up my dates. I want to create an IF function that checks if a date is on the 1st of the month, and if it is, subtracts 1 day to put it at the end of the previous month. However, I find myself unable 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,245 questions
asked 2022-07-15T14:56:12.177+00:00
Owen Laurie 21 Reputation points
edited the question 2023-11-16T06:57:13.4066667+00:00
Roy Li - MSFT 31,886 Reputation points Microsoft Vendor