SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,730 questions
1 answer
One of the answers was accepted by the question author.
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…
asked 2023-11-08T05:38:35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Analyst_SQL
3,551
Reputation points
commented 2023-11-15T05:28:57.24+00:00
Analyst_SQL
3,551
Reputation points
1 answer
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…
asked 2023-11-13T09:44:24.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 82%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mudasir Bari
21
Reputation points
commented 2023-11-14T06:35:03.38+00:00
Mudasir Bari
21
Reputation points
1 answer
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)
asked 2023-11-10T10:13:01.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 91%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
1
Reputation point
commented 2023-11-14T02:17:34.99+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to grant model permission to role
I use a tabular model. I need to grant model permission to one role. Can I use a TSQL statement to do it like Sql server Admin grants permissions? Thank.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 25%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF4%3C/text%3E%3C/svg%3E)
1 answer
Can i use sql sever data tool in enterprise organization with more than 250 employee count SSIS, SSAS with visual studio community free license.
Hi, Help me with your expert advice can we use SQL server data tool in enterprise organization with more than 300 employee count along with SSIS and SSAS with visual studio community free license
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,384 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 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,244 questions
Visual Studio Testing
Visual Studio Testing
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Testing: The act or process of applying tests as a means of analysis or diagnosis.
329 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
966 questions
asked 2023-11-11T10:44:59.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 10%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Amol R Pujari
0
Reputation points
edited an answer 2023-11-13T02:11:12.8333333+00:00
ZoeHui-MSFT
32,901
Reputation points
1 answer
Nested TOPCOUNT between 2 attributes within same dimension using GENERATE function not giving desired results
Hi, I am trying to achieve top 5 subcategories for each of the category in top 5 categories. I have used GENERATE and TOPCOUNT as shown in the below code for achieving the result. But it isn’t working as expected. Instead of returning top 5…
asked 2023-11-06T12:10:10.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
V Anusha
0
Reputation points
commented 2023-11-09T06:53:00.27+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor
1 answer
The workspace database server localhost is not found ( SSAS PROJECT)
Good evening everyone :) I Developed an SSAS project through visual studio. Every thing worked fine but today while trying to open the project but I had this error message: "Error in Visual Studio: You cannot open the IBM file. The workspace…
asked 2023-11-07T17:04:11.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 84%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
khouloud Belhaj
91
Reputation points
commented 2023-11-08T08:42:52.1766667+00:00
khouloud Belhaj
91
Reputation points
1 answer
One of the answers was accepted by the question author.
Create a measures table in SSAS Tabular and Deploy to Azure
With the Import mode in Power BI , I used to create a table for measures. Now I want to do the same with SSAS Tabular and then deploy it.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 16%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 45%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Josip Horacek
0
Reputation points
commented 2023-11-03T01:32:39.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,136
Reputation points Microsoft Employee
1 answer
Calculated Member for SUM of distinct values by dimension
I have a multidimensional cube in SSAS. My fact table looks like this with a reference to a dimension, a column for a value, and a column for the amount. DimMember | TheValue | Amount 1 | 10 | 100 1 | 10 | 300 1 …
asked 2023-10-27T15:58:42.3466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 78%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lane Meadows
5
Reputation points
commented 2023-11-01T09:56:40.9266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Alexei Stoyanovsky
3,416
Reputation points
1 answer
One of the answers was accepted by the question author.
use Time Intelligence in tabular
Hello. I am using a tabular model. I want to use YTD, MTD, etc Time Intelligence . Is it possible to do this on my SQL Server Analysis Services? Thank you in advance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 76%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
1 answer
SQL audit file Rollover is not working
HI all. SQL audit file Rollover is not working I try. The SQL Service account has full permissions to the folder, and I Try disable/enable the audit session to see if it removes the file. and it works for some days. Please give me some advice.
asked 2023-10-17T04:53:52.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uddandam Prasanth (QUANTUM LEAP CONSULTING PRIVAT)
0
Reputation points Microsoft Vendor
answered 2023-10-30T02:44:42.73+00:00
Vahid Ghafarpour
17,950
Reputation points
1 answer
Calculated Member based on a dimension breaks if dimension in query
I have a multidimensional cube in SSAS. I'm created a calculated member to get the Contract Value by Contract Num by dividing by row count (not important really). It all works as long as Contract Num is not in the query. When I add Contract Num to the…
asked 2023-10-25T20:46:11.0833333+00:00
Lane Meadows
5
Reputation points
commented 2023-10-27T10:34:48.53+00:00
Alexei Stoyanovsky
3,416
Reputation points
1 answer
One of the answers was accepted by the question author.
A connection cannot be made to redirector
Hi! When I want to use SSAS, I get this error. A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. How to fix this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 93%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
asked 2023-10-25T20:03:28.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
zubaid ahmed
0
Reputation points
commented 2023-10-26T08:47:18.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,426
Reputation points Microsoft Employee
2 answers
无法连接到 http://localhost/olap/msmdpump.dll。
The connection either timed out or was lost. (Microsoft.AnalysisServices.AdomdClient) 响应状态代码不指示成功: 405 (Method Not Allowed)。 (System.Net.Http)
asked 2023-10-24T03:32:10.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 0%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFQ%3C/text%3E%3C/svg%3E)
feng qiu
0
Reputation points
commented 2023-10-25T01:02:27.3666667+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
get Partition list in Tabular
Hi! How can I get a list of Partitions in Analysis Service? I'm using Tabular. Could anyone help me?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 39%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Importing data from Excel in SQL
I am trying to import data from Excel into SQL using ETITLE: SQL Server Import and Export Wizard and I got below error: File path contains invalid Excel file. Please provide file with .xls, .xlsx, .xlsm, or .xlsb extension. What can I do to successfully…
asked 2023-09-28T07:07:06.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 76%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
vincent Ewere
20
Reputation points
answered 2023-10-18T06:53:15.44+00:00
vincent Ewere
20
Reputation points
1 answer
Implementation of OLAP as a relational database
Hello . I am looking for a solution to the issue of OLAP cubes in the organization. Right now we have a task of taking one cube and replacing it with Tableau reports. In other words, this means taking an OLAP cube, flattening it into a relational…
asked 2023-10-12T09:30:41.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 88%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
amir krugliak
0
Reputation points
commented 2023-10-15T07:49:49.88+00:00
amir krugliak
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Last Date Closing balance is not carry forward against same date?
I have facing issue, when i am applying date filter,after same date opening balance is not carry forward , below is data Create table #Tbl_Customer (C_ID int,C_Name varchar(50),Opening_Date date,Opening_value decimal(10,2)) Create table #tbl_Ledger (ID…
asked 2023-10-13T06:47:28.4433333+00:00
Analyst_SQL
3,551
Reputation points
accepted 2023-10-14T07:35:01.87+00:00
Analyst_SQL
3,551
Reputation points