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…
Custom Grouping in a tabular model
Hi all, Today we have a non tabular cube that we analyze by creating custom groups inside of an excel pivot. For example, using the current period (YYYYMM), we look at financial activity for a current period (ex: 202311), all prior months (202310 and…
Install SQL reporting service
I have a SQL 2016 enterprise server , want to re-install report service , running on windows server 2016 . I have downloaded SQL reporting service 2022 and installed it , it pops to ask install evaluation , developer or express edition , I lost the…
Upgrade SQL Server 2019 (Standard Edition) to SQL Server 2022 (Standard Edition)
I want to upgrade my production SQL Server (2019 Standard Edition) version to SQL Server 2022(Standard Edition) which is hosted on the Azure virtual machine. There are 400-500 databases currently running on the SQL server 2019. So also want to migrate…
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…
Analysis Services 2022 Tabular Model error
When run query in SSMS in { "create": { "database": { "name": "AdventureworksDW2016", "description": "test" } } } i have error: Executing the…
How to fix ---- Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').
i have XMLA script to create the Analysis service database. i try to deploying the script with both primary and secondary server in the AAG environment. i'm facing an issue while running the script - Internal error: An unexpected error occurred (file…
How to complete offline installation of machine learning server components
Hi, I'm trying to install SQL Server 2019 for a course I'm taking and cannot get past the installation process. I keep getting stopped by offline installation error. hyperlinks are provided but i am unable to click or copy them. I'm supposed to create a…
![](https://techprofile.blob.core.windows.net/images/k3pGvNqV6k28ggaVHaTPrQ.png?8D803E)
while processing Analysis service database XMLA script via SQL server agent ,received the Timeout error.
Microsoft.AnalysisServices.Xmla.ConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. --->…
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…
how to reverse comma seprated values.
hi, i have coma separated vales in a table. what i want to reverse it like 'CLP,CAD,GBP' pls tell me how it can be done with out using xml in efficent way. DECLARE @TBL AS TABLE (COLUMN1 NVARCHAR(100)) INSERT INTO @TBL SELECT…
![](https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953)
More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec. Activity ID: eff809b2-03ac-4706-9813-3b96db326c2c Correlation ID: 2d661bae-a418-9231-d2b1-a2fb9cd0c806 Request ID: 474226a5-7911-456b-a636-889fb02a3cc6 T
Hi, Please explain why i am getting the below error when i used a slicer member ID which has 1M records is there any solution for this? More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec. Activity…
![](https://techprofile.blob.core.windows.net/images/JhYB4IiXg0irm9qL1Bmt6A.png?8DAF39)
MDX Cube Hierarchy is behaving from Tabular Cube
Capture.PNG Cube is available in both MDX and tabular formats. The company wants whatever tabular template is available to be incorporated into the mdx version of the cube. However, there are some differences in behavior between MDX and Tabular. Please…
![](https://techprofile.blob.core.windows.net/images/JhYB4IiXg0irm9qL1Bmt6A.png?8DAF39)
processing dimensions in SSAS 2019 takes ten times longer than in SSAS 2017
We are currently observing a significant time difference when processing dimensions in SSAS 2019. Each one of them takes about ten times longer to process and we are unable to find a good reason for it. To test this we've build the following setup: …
Equality of UI input elements vs. database table entities
As you can see in the following image, the user interface of my app has a total of 12 text boxes (6 text boxes in each part) in the seller and buyer sections. The image below is a part of the ERD relating to this application's database; since the…
![](https://techprofile.blob.core.windows.net/images/ZqYdX_8zbEC9qh3iZyHfLA.png?8DA472)
Why won't the Day function reference my dates column in Power BI?
I am trying to run a DAX calculation to clean up my dates. I want to create an IF function that checks if a date is on the 1st of the month, and if it is, subtracts 1 day to put it at the end of the previous month. However, I find myself unable to…
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…
![](https://techprofile.blob.core.windows.net/images/ZqYdX_8zbEC9qh3iZyHfLA.png?8DA472)
![](https://techprofile.blob.core.windows.net/images/ZqYdX_8zbEC9qh3iZyHfLA.png?8DA472)
Expected output required
i want countra Head , Create table #Tbl_Customer (C_ID int,C_Name varchar(50)) Create table #tbl_Ledger (ID int,E_Date date,Debit_Head_ID int,Credit_Head_ID int,T_Amount Decimal(10,2),Countra_ID int ) insert into #Tbl_Customer values…
SQL Server
1<sup>st</sup> Question : Currently customer is buying each SQL license with 10CALS, but In future they may require more CALs. Please advise if they can purchase more CALs later on which will be incorporated with these already purchased…
how to trim values of xml attribute?
Hi, I want to trim @cotd so is there any function which can do it. SELECT LTRIM(RTRIM(R.C.value('@Name','nvarchar(100)'))) FROM @xm.nodes('/test[ fn:lower-case(@cotd) !=""]') AS R(C)
![](https://techprofile.blob.core.windows.net/images/JhYB4IiXg0irm9qL1Bmt6A.png?8DAF39)