A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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 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.
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
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.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
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.
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
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.
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
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.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
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.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
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.
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
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.
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
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.
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
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.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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.
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
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.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
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.
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
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.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
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.
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
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.
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
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.
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
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.