1,248 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
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,248 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,248 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,248 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.
440 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,248 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,248 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,248 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,248 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,248 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,248 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,248 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
1 answer

To get Previous Week value in tabular

I am trying to create a previous week data for my tabular project. As titled, I am having a difficult time getting formula right. How do i write some DAX to sum a total for the previous week? I have all the others down YTD, WTD, MTD etc.

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,248 questions
asked 2020-09-30T07:53:29.987+00:00
KamiFen 121 Reputation points
commented 2020-10-02T03:15:51.827+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Analysis Services returns different results for the same DAX query depending on the execution

Depending on the execution, the following query will return different values: DEFINE VAR _state_id = 11685 MEASURE accumulators[total_distance_when_number_of_copies_is_1] = CALCULATE( SUM( 'order_details'[distance] ) …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,868 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,248 questions
asked 2020-09-23T18:22:00.857+00:00
Hernan Demczuk 6 Reputation points
commented 2020-10-01T07:16:44.377+00:00
Lukas Yu -MSFT 5,816 Reputation points
5 answers

SSAS Prorcessing delays With multiple key columns on Dimension

Hi , We have recently changed dimension key column based on multiple columns (before key col based on 1 column now it is based on 3 columns), which mean we have to add additional columns to all measures to join dim based on 3 combinations. With this…

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,248 questions
asked 2020-09-24T10:26:47.783+00:00
Bala Murali 1 Reputation point
answered 2020-10-01T07:14:35.763+00:00
Lukas Yu -MSFT 5,816 Reputation points
6 answers One of the answers was accepted by the question author.

SSAS 2016 Role question

Hello We are using SSAS 2016 and I have question regarding the roles. I have created a simple role with filter for Employee Number , and if I test the role in Browse (SSAS) and select the role name it works just fine but it does NOT if I specify a…

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,248 questions
asked 2020-09-29T05:59:45.013+00:00
Uri Dimant 206 Reputation points
answered 2020-09-29T07:49:34.883+00:00
Uri Dimant 206 Reputation points
1 answer

Cannot add calculation group to SSAS Tabular 1500 with direct query to SQL server

Hi, When I try to add a calculation group to a clean SSAS tabular 1500 project in direct query mode linked to a single SQL Server table, I get the following error: Failed to save modifications to the server. Error returned: 'All partitions using…

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,248 questions
asked 2020-09-04T15:56:30.983+00:00
Martijn 1 Reputation point
commented 2020-09-29T06:36:05.22+00:00
Tlou, Violet 21 Reputation points
2 answers One of the answers was accepted by the question author.

using BLANK function

Hi, I have a question regarding the BLANK() function in DAX in Tabular. I am asked to display BLANK wherever I get 0. This is what I am doing: Total count (60dg):=if([Rivers (60dg)]/[salePrice] = 0, BLANK(), [Rivers (60dg)]/[salePrice]) I want…

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,248 questions
asked 2020-09-28T10:33:27.793+00:00
DhanashreePrasun 61 Reputation points
accepted 2020-09-29T05:33:26.553+00:00
DhanashreePrasun 61 Reputation points
1 answer One of the answers was accepted by the question author.

SQLServer 2019, Polybase and Tabular Model

All, From SQL Server 2019, how do I connect to SQL Server Analysis Server (Tabular Model)/Azure Analysis Service using "CREATE EXTERNAL DATA SOURCE". I would like to connect to it using Polybase and extract data from the Tabular data model.…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
440 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,868 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,248 questions
asked 2020-09-27T16:04:45.72+00:00
grajee 346 Reputation points
accepted 2020-09-27T16:59:43.64+00:00
grajee 346 Reputation points
3 answers One of the answers was accepted by the question author.

Analysis Services Tabular Model excel in sharepoint

I have created an analysis services tabular model. It has a database connection and a couple of excel files as data sources. When syncing the azure analysis services from the portal, the data does not update. It only updates if I publish from visual…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
440 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,248 questions
asked 2020-09-16T11:58:48.063+00:00
Palios, Jason 81 Reputation points
commented 2020-09-27T11:21:33.917+00:00
Juli Lis 1 Reputation point
1 answer One of the answers was accepted by the question author.

Hiding part Dimension values from some users

Hi all, We have Tabular model with unit Dimension ( like :Hospital 1, Hospital 2, etc). We want to hide few units(hospitals) from dimension member list to the Users . Rows for all the hospitals will be used for some other Measure calculation 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,248 questions
asked 2020-09-22T02:05:57.597+00:00
KamiFen 121 Reputation points
accepted 2020-09-25T09:52:04.137+00:00
KamiFen 121 Reputation points
1 answer One of the answers was accepted by the question author.

Cube Member ID, Name, and Value

Hello; What is the best way to provide an end user the ability to see view a dimension attribute member by either its Key, Name, or Value at their discretion. I'm using Excel pivot table for the front end to access the SSAS cube. For example 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,248 questions
asked 2020-09-22T15:42:55.933+00:00
Dave Schmitz 21 Reputation points
accepted 2020-09-23T12:32:46.58+00:00
Dave Schmitz 21 Reputation points