1,258 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

Create durable key in dimension

My Customer dimension has columns customer_key (surrogate key int), customer_number (ID from source system) and customer_name. I need to implement SCD 2 to track changes. Business case is that customer_number can change for customer in time. So, I need…

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,258 questions
asked 2020-10-14T13:18:09.23+00:00
Ales Ventus 46 Reputation points
commented 2020-10-15T15:08:35.38+00:00
21986829 481 Reputation points
2 answers

ADOMD.NET Connection ignores User ID property when connecting to SSAS on-premise over native connection, not http

We are trying to execute MDX statements from .NET Framework 4.5 application. It works if windows identity that App pool runs as has access to the cube. According to the documentation…

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,258 questions
asked 2020-10-06T18:48:01.237+00:00
Tanya Ershova 6 Reputation points
commented 2020-10-14T06:38:41.133+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers One of the answers was accepted by the question author.

SSAS Synchronization locking(?) issue

Hi, We are running SSAS Tabular (2019, same issue on 2017) We have an environment with one server acting dedicated as a processing server (we can call it server 1) and another one dedicated for user query load (we can call it server 2). Multiple…

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,258 questions
asked 2020-09-28T11:49:39.573+00:00
Stefan 191 Reputation points
accepted 2020-10-13T06:28:05.92+00:00
Stefan 191 Reputation points
1 answer

How to create ISAPI Filter in visual studio 2012 onwards

Hi Team, We are using MSMD Pump for our analysis services. where, it is hosted on IIS and shared URL to users those are accessing our cubes without having explicit access on our cube server. But now we have a requirement to track all the request…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,526 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,258 questions
asked 2020-10-07T15:34:21.47+00:00
Mukesh Dutt 1 Reputation point
commented 2020-10-13T02:44:20.793+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

SSAS - Query mode - Hybrid in 2019

Hi, I'm currently working on a tabular model project and I've been reading about the two modes for query mode, Direct Query and In-Memory. In the 2012 version for VS there's a option to deploy the solution in Hybrid mode (compatibility 1100 i think),…

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,258 questions
asked 2020-10-06T15:00:17.877+00:00
Luis Molina 6 Reputation points
answered 2020-10-12T21:55:09.387+00:00
Darren Gosbell 2,376 Reputation points
1 answer One of the answers was accepted by the question author.

Query to get a list of Paritions

All, Would the DMV -- $SYSTEM.TMSCHEMA_PARTITIONS -- on AAS give me a list of Partitions in a Analysis Service Tabular Model database? We are trying to see if the "Basic Tier B1/B2" Pricing Tier would help us get more value for the same…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 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,258 questions
asked 2020-10-07T22:50:55.777+00:00
grajee 346 Reputation points
accepted 2020-10-12T05:23:12.457+00:00
grajee 346 Reputation points
3 answers One of the answers was accepted by the question author.

dimension security based on hierarchy node

i´m trying to switch from standard permission handling based on leave level (dedicated cost center) like this NonEmpty ( [cost center].[cost center].Members, ( StrToMember ("[user].[user].[" + UserName () + "]"), …

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,258 questions
asked 2020-10-02T13:45:09.343+00:00
Antoine Krebs 101 Reputation points
accepted 2020-10-09T05:24:15.767+00:00
Antoine Krebs 101 Reputation points
1 answer

Manage all measures under one table

I've created some measures and I've created a master table, Now I want to relate all measure to this table. Is that possible? How it can be done?

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,258 questions
asked 2020-10-01T09:11:05.197+00:00
KamiFen 121 Reputation points
commented 2020-10-09T02:31:46.36+00:00
Lukas Yu -MSFT 5,816 Reputation points
4 answers

SSAS Tabular, do not see table after import

I am connecting to an Oracle database. I want to use a native sql query for my source as opposed to a table. I select a table cause I don't see an option to add a query, then once I have the connection I create a query using = Value.NativeQuery(... …

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,258 questions
asked 2020-09-28T20:53:09.36+00:00
Computer Mike 86 Reputation points
answered 2020-10-09T02:28:02.157+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Application of RLS in SSAS does not work in Power BI

When I apply RLS to a dimension in SSAS, hiding a particular column, in Power BI, the table I have with that column, simply disappears. In this power BI table, I have columns of various dimensions, what I want is for the table to be visible and for…

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,258 questions
asked 2020-10-02T19:11:40.163+00:00
Nelson Alexandre da Silva Pereira 1 Reputation point
commented 2020-10-09T02:14:18.783+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

allocation of expenses by sales in dax from two unrelated columns

I have 2 tables: sales contains: 1) employee 2) customer 3) sales amount 2) costs contains 1) customer 2) operation 3) expenses amount descrition: salary data in costs table displayed as customer, which is equal to employee from sales table. And…

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,258 questions
asked 2020-10-02T09:08:26.813+00:00
alexstarikov0 1 Reputation point
commented 2020-10-09T02:13:13.277+00:00
Lukas Yu -MSFT 5,816 Reputation points
4 answers One of the answers was accepted by the question author.

Restructuring Tabule Model in SSAS

Hi Experts, I am working on creating new SSAS models and designing power bi reports from them. For now I could connect through Power BI to Tabular Model created but need few suggestions: Can move the Columns in tabular model in different folder? …

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,258 questions
asked 2020-09-22T17:58:50.137+00:00
Swapnil 216 Reputation points
accepted 2020-10-08T15:37:56.64+00:00
Swapnil 216 Reputation points
2 answers One of the answers was accepted by the question author.

The best way to implement such schema in SSAS

Hi All, I would be grateful for your advice about the best way to implement in multidimensional cube the following situation: I have got a standard star-schema (please see attached picture) Fact_Actions - fact table Dim_Agreements, Dim_Users and so…

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,258 questions
asked 2020-10-06T13:44:06.857+00:00
Sergey 21 Reputation points
accepted 2020-10-07T16:38:26.957+00:00
Sergey 21 Reputation points
1 answer

DAX Approach to Inventory Problem?

I have data in Azure Analysis Services (Tabular) that looks like the following table. I need to create two calculated columns for the Date that the Inventory Changed and the Amount of the Inventory Change. I think and IF function can take care of me…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 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,258 questions
asked 2020-09-30T00:51:29.637+00:00
james.h.robinson.csm@gmail.com 6 Reputation points
commented 2020-10-07T06:43:06.397+00:00
HarithaMaddi-MSFT 10,136 Reputation points
2 answers

How to get the users using cube frequently

Hi , I want to get list of users who access cube regularly. With my very limited understanding I was thinking to run Profiler on server for few days to get the list of users. Is this the right option?

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,258 questions
asked 2020-10-02T07:45:16.577+00:00
KamiFen 121 Reputation points
commented 2020-10-06T09:32:35.75+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

How to change dimension display oder

How could I change the dimensions order of SSAS project as I wanted ? I try to drag them but it not works. Is there any setting somewhere in visual studio that I havenot found ?

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,258 questions
asked 2020-10-02T07:29:51.65+00:00
Muhammad Shami 61 Reputation points
commented 2020-10-06T09:32:08.913+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Analysis Server - Calculation with Dimension (Multidimensional Cube)

Hi, maybe a simple question, but i'm new with cubes and so on and thererfore i need a little help. Szenarion: Dimension Active with values yes and no Measure: [Measure].[User] It works fine but i need a percentage value also e.g. Date …

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,258 questions
asked 2020-09-30T06:02:40.91+00:00
DataNinja 21 Reputation points
commented 2020-10-06T07:41:59.467+00:00
Alexei Stoyanovsky 3,416 Reputation points
2 answers One of the answers was accepted by the question author.

Deploy issue of SSAS

Severity Code Description Project File Line Suppression State Warning Database [xxxxDB] : The database has no Time dimension. Consider creating one. 0

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,258 questions
asked 2020-10-02T03:57:38.293+00:00
Muhammad Shami 61 Reputation points
accepted 2020-10-02T07:27:33.177+00:00
Muhammad Shami 61 Reputation points
1 answer

ssas tabular unspecified error - Visual Studio 2017 SSDT

I have a tabular model, I just added a few measures and deployed it in Microsoft Sql server management studio, when I am processing the partition, either in Visual studio or in sql server mgmt studio, I get below error, this is the partition where…

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,258 questions
asked 2020-09-22T20:27:12.713+00:00
Vishwanatham, Gautam 1 Reputation point
commented 2020-10-02T03:21:46.69+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Problems with DirectQuery and Oracle Sources - "An error was encountered in the transport layer"

Hello, Im developing reports in Power BI Desktop (RS - don't think it's too important here) with Live Query connection to SSAS 2017, and SSAS 2017 is connected to Oracle sources using Direct Query. I would like to know what are the inevitable things…

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,258 questions
asked 2020-09-24T15:54:51.927+00:00
Ricardo Mota Freitas 1 Reputation point
commented 2020-10-02T03:18:29.543+00:00
Lukas Yu -MSFT 5,816 Reputation points