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…
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?
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…
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"
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…
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…
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
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.
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…
l'installation de microsoft SQL server 2014 edition a échoué 2054422498
l'installation de microsoft SQL server 2014 edition a échoué 2054422498
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.…
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?
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…
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…
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…
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…
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…
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…
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 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…