1,372 questions with SQL Server Analysis Services tags

Sort by: Updated
1 answer

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) …

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.

606 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,372 questions
asked 2022-07-13T15:04:26.47+00:00
Spencer-Jones, Mike 6 Reputation points
commented 2024-09-26T10:16:56.4066667+00:00
Silviu Vladutu BCR 0 Reputation points
1 answer

Deselecting Members In An Excel PivotTable Leads To Missing Rows version 2

Dear community, I followed the steps from this guide…

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,372 questions
Microsoft 365 and Office | Excel | For business | Windows
asked 2024-09-23T14:04:55.0333333+00:00
Philip Østergaard Braun 0 Reputation points
commented 2024-09-25T12:53:53.2+00:00
Philip Østergaard Braun 0 Reputation points
1 answer One of the answers was accepted by the question author.

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…

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,372 questions
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,717 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2024-09-23T06:43:51.1533333+00:00
PANDEY Prashant 145 Reputation points
commented 2024-09-24T11:17:01.93+00:00
PANDEY Prashant 145 Reputation points
2 answers One of the answers was accepted by the question author.

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…

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,372 questions
asked 2024-09-19T10:53:17.7133333+00:00
greg lipman 81 Reputation points
commented 2024-09-23T13:16:14.75+00:00
greg lipman 81 Reputation points
2 answers

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…

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,372 questions
Microsoft 365 and Office | Excel | For business | Windows
asked 2021-05-03T21:26:19.957+00:00
Samir abdelmalek 21 Reputation points
edited a comment 2024-09-19T02:30:33.8966667+00:00
MyName-0111 0 Reputation points
1 answer

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"

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.

3,163 questions
SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 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,372 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2024-09-14T09:11:58.3833333+00:00
võ thị tuyết ngân 20 Reputation points
commented 2024-09-17T20:52:32.24+00:00
Erland Sommarskog 134.6K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

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…

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,372 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2024-09-15T05:21:37.1933333+00:00
PANDEY Prashant 145 Reputation points
accepted 2024-09-17T07:03:06.9133333+00:00
PANDEY Prashant 145 Reputation points
1 answer

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…

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,372 questions
asked 2024-09-10T11:47:40.22+00:00
BOBASITH 0 Reputation points
commented 2024-09-12T06:36:29.57+00:00
BOBASITH 0 Reputation points
2 answers

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

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,372 questions
asked 2024-09-10T06:54:23.06+00:00
Ramana Kopparapu 306 Reputation points
commented 2024-09-12T03:07:36.93+00:00
MikeyQiaoMSFT-0444 3,310 Reputation points
1 answer One of the answers was accepted by the question author.

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.

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,372 questions
asked 2024-09-08T13:18:32.93+00:00
Ramana Kopparapu 306 Reputation points
accepted 2024-09-10T06:40:18.75+00:00
Ramana Kopparapu 306 Reputation points
1 answer

l'installation de microsoft SQL server 2014 edition a échoué 2054422498

l'installation de microsoft SQL server 2014 edition a échoué 2054422498

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,372 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2024-08-29T11:36:28.49+00:00
BMWIEM 0 Reputation points
commented 2024-09-05T05:56:27.1+00:00
Anonymous
1 answer

Can i make data marts in SSAS?

I followed kimball approach but the problem is I didn't make data marts before star schema. Now my question is can I make data marts in SSAS or is it mandatory to make these marts before schema in kimball approach?

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 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,372 questions
asked 2021-04-01T16:22:30+00:00
zara 1 Reputation point
commented 2024-09-04T11:37:15.66+00:00
Quien 0 Reputation points
1 answer

Unable to work on SSAS, its showing error

Hi All, I have installed SQL Server 2022, Visual Studio 2022 and SSAS. But I am getting error while trying to create the Data Source View. Here is the error: TITLE: Microsoft SQL Server Native Client 11.0 ------------------------------ A network-related…

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,372 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2024-08-28T11:09:59.3033333+00:00
SUNIL B S 0 Reputation points
commented 2024-08-30T16:13:53.21+00:00
SUNIL B S 0 Reputation points
0 answers

Cannot find SQL Server Data Tools in Start Menu after installing Visual Studio 2022 on Windows 10 (Build 17763)

I have 64bit-Windows 10 Build 17763 (maybe the problem ?) and installed Visual Studio 2022 to get SQL Server Data Tools (selected from Options of Data Storage and Processing) for using in SQL Server BI. After the installation, I can't see SQL Server Data…

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.

3,163 questions
SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,795 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,372 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2024-08-23T10:14:58.29+00:00
commented 2024-08-25T14:48:52.5733333+00:00
1 answer

VS solution cannot open .bim value of '311' is not valid

I have a VS solution tabular model .bim that has been created and deployed to our production and development environment. The data is being processed nightly through Azure. HOwever, I am now not able to open the .bim in the solution. I receive 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,372 questions
asked 2021-04-26T14:52:40.99+00:00
Tina Douglass 6 Reputation points
commented 2024-08-22T13:26:56.44+00:00
Melissa Asher 0 Reputation points
1 answer

SSAS Connection String - Application Name

Hi We are using the SSAS DMV's to extract usage information via DISCOVERY_SESSIONS, DISCOVERY_CONNECTIONS, and DISCOVERY_COMMANDS. DISCOVERY_CONNECTIONS has a column for the application (CONNECTION_HOST_APPLICATION). This is very handy as we have our…

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,372 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,749 questions
asked 2024-08-20T15:12:02.86+00:00
Trevor Howe (SI) 0 Reputation points
commented 2024-08-21T05:56:51.9066667+00:00
Trevor Howe (SI) 0 Reputation points
1 answer

Analysis Services reads data from a data source, but gives connection error while processing multidimensional analysis

  I have built an Analysis Services Multidimensional project using Microsoft Visual Studio Professional 2022 with the SQL Server Analysis Services 16.0 extension connected to Analysis Services on a remote SQL Server 2019 instance. The Visual Studio…

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,372 questions
asked 2024-07-24T09:58:05.98+00:00
Goglio, Gianluigi [NMS Group] 20 Reputation points
commented 2024-08-19T08:17:53.4433333+00:00
Goglio, Gianluigi [NMS Group] 20 Reputation points
1 answer

SQL OLAP - The file '<ccon>NLevelDecodeStore_<GUID>.tmp</ccon>' could not be deleted. Please check the file for permissions.

Hello, I use MS SQL Server 2022 with Analysis Services. I see a lot of errors in the log: The file '<ccon>NLevelDecodeStore_<GUID>.tmp</ccon>' could not be deleted. Please check the file for permissions. The file…

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,372 questions
asked 2024-08-18T09:56:33.8133333+00:00
Zbynek Polisensky 0 Reputation points
commented 2024-08-18T15:58:44.45+00:00
Zbynek Polisensky 0 Reputation points
1 answer

Unable to connect to Azure Virtual Machine(VM) with SQL Server Analysis Services(SSAS) installed using SQL Server Management Studio(SSMS)

I'm trying to deploy an MSOLAP multidimensional cube, using Visual Studio, to Azure VM with SSAS installed. However, the deployment failed due to the following error Severity Code Description Project File Line Suppression State Error The project could…

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,372 questions
asked 2024-07-29T20:42:58.5333333+00:00
Sunny Juneja 0 Reputation points
answered 2024-08-15T10:38:49.4333333+00:00
Greg Low 2,105 Reputation points Microsoft Regional Director
4 answers One of the answers was accepted by the question author.

Auto Refresh Tabular Model

Hi All, I need to have my SSAS Tabular Model auto refreshed every day at certain time so that newly added data in tables are pulled in model and subsequently in Power BI reports. Can anyone guide me to have steps to do the needful? 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,372 questions
asked 2021-02-01T22:16:35.507+00:00
Swapnil 216 Reputation points
commented 2024-08-09T19:50:46.8733333+00:00
Michael Zanovec (OTS) 0 Reputation points