1,258 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
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,258 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.
13,215 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-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,258 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,258 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,258 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,258 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.
443 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.
13,215 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-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.
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-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,258 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,258 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
3 answers

Different Measures calculation according to Client/Date

Hi all!! I'm new to SSAS Tabular Mode and DAX and I was wondering if anyone could help me, please. I have to create a Measure that uses different formulas accordingly to the Client and Date dimensions. For instance, I have a Measure named…

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-08-19T17:03:53.26+00:00
Henrique Lima 1 Reputation point
answered 2020-09-23T00:47:09.873+00:00
Henrique Lima 1 Reputation point
4 answers

SSAS database backup

I tried to backup SSAS databases (2008 R2) by using query in SSMS, but it is overwriting previous day's backup. How to take backup without overwriting previous backup. I need to maintain at least 7 days of backup. Currently I schedule a job in SQL Server…

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-17T07:30:58.713+00:00
kumar-9444 121 Reputation points
answered 2020-09-21T01:53:32.163+00:00
m 4,271 Reputation points
9 answers

MDX query from SSAS change type

Hi All, I have one MDX query and It takes the data directly from SSAS. The problem is that some of the measures are coming as string but not as a number like they are in the SSAS. I want to change the data type or something else. Now Im trying to use…

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-15T06:44:41.743+00:00
Dimitar 1 Reputation point
answered 2020-09-21T01:52:18.403+00:00
m 4,271 Reputation points
2 answers One of the answers was accepted by the question author.

SINTAXIS MAL ESCRITA FUNCION SELECTEDVALUE(<columnName>[, <alternateResult>])

¿Por que la funcion SELECTEDVALUE esta escrita : SELECTEDVALUE(<columnName>[, <alternateResult>]) ; deberia ser : SELECTEDVALUE(<columnName>,[ <alternateResult>] , el corchete esta dentro del primer termino y deberia estar dentro…

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
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,445 questions
asked 2020-09-19T11:04:49.963+00:00
CHRISTIAN ANDRES SERNA GAVIRIA 96 Reputation points
answered 2020-09-21T01:42:40.557+00:00
Ian Xue (Shanghai Wicresoft Co., Ltd.) 33,376 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SQL SERVER Tabular Model - Bi-directtional filter suggestions

Hello All, We have a requirement to show values from all dimension on Row Level Security implemented on particular dimension based Fact Table Join . Lets say we have Fact table which is connected with 3 dimension ( dimA, dimB, dimC) if row level…

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-09T09:03:39.22+00:00
Ravi Moorthy-Naganathan 21 Reputation points
commented 2020-09-18T12:06:59.413+00:00
Ravi Moorthy-Naganathan 21 Reputation points
2 answers

SSAS HTTP Connection-msmdpump.dll

Hi, I am connecting to an SSAS server from IIS using HTTP connection(msmdpump.dll). I follow the steps mentioned in this link …

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-11T04:28:38.16+00:00
Shermin Ismail 1 Reputation point
commented 2020-09-18T05:58:47.29+00:00
Darren Gosbell 2,376 Reputation points
2 answers

MDX DYNAMIC CASE STATEMENT Using Perameter

I tried to build dynamic MDX case statement using Parameter, but it shows blank results. can anyone help to resolve this issue? WITH MEMBER ContinentRollUP AS CASE WHEN [DIM_JOB_BILLING_TYPE_V].[GLJC_TYPE]…

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-09T16:11:08.353+00:00
sudhakar yeta 1 Reputation point
answered 2020-09-18T05:57:19.007+00:00
Darren Gosbell 2,376 Reputation points
1 answer

Synchronization job failed when service MSSQLServerOLAPService crashed -[ Task category 256, event ID 22 ] -- File system error: the process can not access the file beacuse it is being used by the another process <file path>

Hi All, SSAS DB synchronization failed with error: "Synchronization Database Error: The connection eiter timed out or was lost" When checked MSSQLServerOLAPService service was stopped and it logged below error in application log(event…

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-08T06:24:41.39+00:00
Komal Sahu 311 Reputation points
commented 2020-09-18T03:53:36.197+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

MDX query to get max date on a range

Hi, I want to query the tabular model to get 1st date and last date of first month of current quarter and then find the max of snaphot date that lies in that range.Can you pls help with the query Date column =SnapshotDate Measure= OrderQty

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-08T13:07:44.24+00:00
PV 21 Reputation points
commented 2020-09-18T03:52:22.637+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

Intellisense in Power Query Not Working

I've been working to setup some reports using Power Query by CUBE functions. It's been very convenience to setup just by typing the double quotes (") to begin a CUBE formula and MS Intellisense automatically display a drop down list of all the…

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-10T19:27:17.81+00:00
Myra 1 Reputation point
commented 2020-09-18T03:47:09.187+00:00
Lukas Yu -MSFT 5,816 Reputation points