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.
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
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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…
![](https://techprofile.blob.core.windows.net/images/JhYB4IiXg0irm9qL1Bmt6A.png?8DAF39)
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…
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.
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,…
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 …
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.
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.
![](https://techprofile.blob.core.windows.net/images/U1Jln6XVxUOXS5Rme1kflg.png?8DC69F)
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…
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?
无法连接到 http://localhost/olap/msmdpump.dll。
The connection either timed out or was lost. (Microsoft.AnalysisServices.AdomdClient) 响应状态代码不指示成功: 405 (Method Not Allowed)。 (System.Net.Http)
![](https://techprofile.blob.core.windows.net/images/JhYB4IiXg0irm9qL1Bmt6A.png?8DAF39)
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?
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…
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…
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…
How do I pass all the JSON packets received in that particular tumbling window to the Javascript UDF function from the Azure Stream Analytics Query?
Below is my Azure Stream Analytics query. In this query, I have set the tumbling window for 10 seconds, and whatever data I will be receiving in these 10 seconds, I wanted to pass these complete packets in the "AggrFunction(IotMessage)" UDF…
Using 64bit HANA ODBC driver issue in VS2022 tabular project
Hello, I'm trying to develop a tabular project for SSAS 2019 on VS2022 17.2.2. The data source is our HANA database (64bit). THe SSAS 2019 enterprise is 64bit. The ODBC driver is "HDBODBC". It is a 64bit driver. As VS2022 is a…
SSAS related problem
New to SSAS. I have SQL Server, do I need to pay extra for ssas? By the way, when I look up information, I see that Azure Analysis Services has similar functions. Which one should I choose?
![](https://techprofile.blob.core.windows.net/images/_KR_hQAAAwAAAAAAAAAAAA.png?8D8440)
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…