SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,785 questions
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…
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…
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
0 answers
Why I cannot open SSAS DataSource Connection String in SSMS 20.2.30.0
Trying to manage Analysis Services Cube Data Source connections via SSMS 20.2.30.0 fails with error "tree node should not be null in DropDownTreeView::GetNodeId Parameter name: node" when I click on the three dots to the right side of the…
asked 2024-07-23T19:32:28.9233333+00:00
Nenea Nelu
66
Reputation points
commented 2024-07-30T14:55:12.9466667+00:00
Nenea Nelu
66
Reputation points
0 answers
MDX request to System SSAS cube does not display the results
Hello, I'm trying to do some requests to analyse the usage of our cubes. All requests on $SYSTEM.DISCOVER_SESSIONS made in Microsoft SQL Server Studio or even in PowerShell are working well. However, everytime I try to request…
asked 2024-07-18T12:22:16.54+00:00
CAUDMONT Amaury
0
Reputation points
asked 2024-07-18T12:22:16.54+00:00
CAUDMONT Amaury
0
Reputation points
0 answers
Modelos tabulares no liberan memoria
Buenos dias, paso a consultar por un problema. Tengo varios modelos tabulares, y cada vez que proceso alguna partición, la memoria de mi servidor llega a 85/90%. Una vez terminado el procesamiento, la memoria queda en esos niveles, por lo que si quiero…
asked 2024-05-17T11:56:15.51+00:00
Roberto Lavisse
0
Reputation points
asked 2024-05-17T11:56:15.51+00:00
Roberto Lavisse
0
Reputation points
0 answers
ODBC Connection Error- SSMS
We are getting ODBC/Connection Error for few of the jobs which are running in SSAS. while some other jobs are running fine with the same ODBC Connection. Error: Message Executed as user: NA\ps498921. Microsoft.AnalysisServices.Xmla.XmlaException: The…
asked 2024-03-05T05:40:44.61+00:00
KANCHI BIANCA (CRGL-THIRDPARTY.COM)
5
Reputation points
commented 2024-04-15T15:28:20.3+00:00
MANJUNATH RAMAMURTHY
0
Reputation points
0 answers
Error While a partition is processed: "The JSON DDL request failed with the following error: The server sent an unrecognizable response.;Root element is missing"
We got this error when it was processing a tabular model partition in SSAS from an SSIS package. This is the JSON that process the partition: { "refresh": { "type": "full", "objects": [ { "database":…
asked 2024-01-10T18:43:53.01+00:00
Irama Abello Moreno
0
Reputation points
commented 2024-02-12T10:47:41.44+00:00
Greg Low
1,760
Reputation points Microsoft Regional Director
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.
5,107 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,282 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
30,566
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…
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
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…
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
0 answers
Designing an entity relationship diagram (ERD) for invoice printing software
The invoice-printing program is depicted in the figure below. I'd like to search for invoices based on the buyer's full name (Natural person/legal entity full name) or the invoice date to find all invoices associated with those two situations. For…
asked 2023-11-11T23:55:40.4266667+00:00
Reza Jaferi
331
Reputation points
edited the question 2023-11-15T11:40:39.7266667+00:00
Reza Jaferi
331
Reputation points
0 answers
Counting distinct data from FACT table returns correct numbers but SSAS cube does not
Hi, I have a problem with distinct count measures in SSAS cube. When I check my FACT table numbers - they are correct but distinct count measure (in combination with location data) in a cube shows different numbers. When I do not combine location data,…
asked 2023-10-27T08:01:12.6933333+00:00
Josip Horacek
0
Reputation points
commented 2023-11-03T01:32:39.81+00:00
Bhargava-MSFT
31,011
Reputation points Microsoft Employee
0 answers
VM Doesn't See AAD Cloud-Only Users But Sees Users Created From On Premises AD
Hello, I have an Azure virtual machine running SQL Server Analysis Services. This VM is joined to my company's domain. We recently migrated from a hybrid setup where we had an on-premise active directory running on a windows server, to a cloud-only Azure…
0 answers
How to create an average, rank, total measures over a field (by dynamic period) in SSAS?
Hi everyone, (I post here a question I created in stackoverflow, hopefully I will have better luck here) I'm new with SSAS technology and I have an existing cube that measures hits by page on web site. In few words the cube is structured as followed: a…
0 answers
Data is get calculate after Opening date
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be get from #tbl_Account_L_Four and Opening_Value ,if Opening_Date is null then data will get from #tbl_transection table. Secondly Opening_Date if…
asked 2023-09-20T08:25:32.1466667+00:00
Analyst_SQL
3,551
Reputation points
commented 2023-09-27T05:43:52.49+00:00
Analyst_SQL
3,551
Reputation points
0 answers
What version of SSAS support the DAX expressions FIRSTNONBLANKVALUE and LASTNONBLANKVALUE
I am using SSAS 15.0.32.50 and I used FIRSTNONBLANKVALUE and LASTNONBLANKVALUE DAX expressions in my measures. The model gets deployed without an issue but when I try to use these measures I get an error "Expression: Failed to resolve name…
asked 2023-09-13T14:22:23.0533333+00:00
Subash Basnayake
61
Reputation points
asked 2023-09-13T14:22:23.0533333+00:00
Subash Basnayake
61
Reputation points
0 answers
how to assign roles in Azure Analysis Services (AAS) to visualize information in power bi by row level security either way (Dynamic or static)?
How to assign roles in azure analysis services to visualize information in power bi by row level security (Dynamic or static)? Do you have to assign the role from visual studio, from SQL Server Management Studio (SSMS) or from both? We have tried to…
asked 2023-08-25T22:22:06.3966667+00:00
Anonymous
commented 2023-09-01T22:52:06.9533333+00:00
QuantumCache
20,266
Reputation points
0 answers
i am importing this excel file but i am stuck with this error.
i tried all the the possible things using Youtube but still got the error , i checked the import and export wizard but everything looks fine there please help me out in here,
asked 2023-08-30T07:46:11.68+00:00
shahmeer ali
0
Reputation points
edited the question 2023-08-31T02:25:36.3966667+00:00
Emi Zhang-MSFT
24,986
Reputation points Microsoft Vendor
0 answers
Problem In Accessing Linked Server to SSAS
I have created a Linked Server to SSAS (tabular) from My SQL Server Without a Catalog Name. I Expect to See all the Data Models and their Tables. However, I only see the tables related to One DM and all other Data model just shows up without any table.…
asked 2023-08-26T00:14:22.8833333+00:00
swabhiman das
20
Reputation points
edited the question 2023-08-26T06:45:49.66+00:00
swabhiman das
20
Reputation points
0 answers
MDX Filter data set on Current Year
Hi there, I’m a very beginner with MDX scripting. I try to find a way to filter a dataset on the current year, in a MDX query. My query is working well when I use à constant such as « 2023 », but no data are returned if I use à variable such…
asked 2023-08-24T19:35:18.0066667+00:00
Géraldine
0
Reputation points
commented 2023-08-25T10:30:22.3633333+00:00
Alexei Stoyanovsky
3,416
Reputation points