1,278 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
0 answers

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,278 questions
asked 2024-09-19T10:53:17.7133333+00:00
greg lipman 61 Reputation points
2 answers

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?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 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,278 questions
asked 2024-09-18T13:04:27.5766667+00:00
mm 0 Reputation points
answered 2024-09-19T09:46:45.8766667+00:00
MikeyQiaoMSFT-0444 2,790 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,278 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,708 questions
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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 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,915 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,567 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,278 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 110.4K Reputation points MVP
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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 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,278 questions
asked 2024-09-15T05:21:37.1933333+00:00
PANDEY Prashant 105 Reputation points
accepted 2024-09-17T07:03:06.9133333+00:00
PANDEY Prashant 105 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,278 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,278 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 2,790 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,278 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
4 answers

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…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,957 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,278 questions
asked 2020-09-22T10:05:03.96+00:00
Vladimir Kovalenko 11 Reputation points
commented 2024-09-09T14:21:37.4933333+00:00
Ali Alyaqubi 0 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 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,278 questions
asked 2024-08-29T11:36:28.49+00:00
BMWIEM 0 Reputation points
commented 2024-09-05T05:56:27.1+00:00
LucyChenMSFT-4874 4,430 Reputation points
5 answers One of the answers was accepted by the question author.

Analysis Services Processing Task: Error A connection cannot be made

Hi, We are executing an SSIS package.. it fails with the below error Analysis Services Processing Task: Error A connection cannot be made. Ensure that the server is running. We have a separate SSAS instance on this server which is up and running.…

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,278 questions
asked 2024-09-03T04:30:09.63+00:00
Bilal H. Bhatt 116 Reputation points
accepted 2024-09-05T04:16:12.0433333+00:00
Bilal H. Bhatt 116 Reputation points
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,567 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,278 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 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,278 questions
asked 2024-08-28T11:09:59.3033333+00:00
Sunil Sathyanarayana 0 Reputation points
commented 2024-08-30T16:13:53.21+00:00
Sunil Sathyanarayana 0 Reputation points
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,690 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,278 questions
asked 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow 80 Reputation points
commented 2024-08-27T00:07:40.5466667+00:00
Greg Low 1,760 Reputation points Microsoft Regional Director
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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 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,915 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,567 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,278 questions
asked 2024-08-23T10:14:58.29+00:00
Working Soft 0 Reputation points
commented 2024-08-25T14:48:52.5733333+00:00
Working Soft 0 Reputation points
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,278 questions
asked 2021-04-26T14:52:40.99+00:00
Tina Douglass 1 Reputation point
commented 2024-08-22T13:26:56.44+00:00
Melissa Asher 0 Reputation points
1 answer

Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length

Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,874 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,278 questions
asked 2024-07-22T17:24:40.0233333+00:00
Michael King 0 Reputation points
commented 2024-08-21T20:52:13.6233333+00:00
Erland Sommarskog 110.4K Reputation points MVP
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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 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,278 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,278 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,278 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