1,258 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
1 answer

Calcualte Sum(Price) Ignoring one level

I need to create a measure which will group by vendorname and account name and pick max price and sum price at vendor level and account level ignore subaccount level. Create Derived table as shown in excel and do sum of price on derived table …

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-27T00:08:14.97+00:00
Ra 1 Reputation point
commented 2020-09-01T09:07:51.767+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Update ALl measures using MDX Script in the calculations tab

HI, I updated all measures using MDX Script in the calculations tab SCOPE([Measures].AllMembers); THIS = CASE [Measures].AllMembers WHEN [Measures].[MTD] THEN IIF ([Measures].[MTD] = 0 AND [Measures].[QTD] = 0 AND [Measures].[YTD] = 0, null,…

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-26T10:13:06.22+00:00
Narendra Reddy 1 Reputation point
answered 2020-08-28T06:41:03.257+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

integration services ne figure pas dans la liste des fonctionnalités partagées de sql server

je suis incapable de déployer les packages ssis car je n'ai pas le catalogue ssisdb après plusieurs essais je trouve que l'origine de problème le manque de la fonctionnalité integration services j'ai essayé de modifier l'installation en ajoutant cette…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 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-08-11T12:45:34.333+00:00
emna khiari 1 Reputation point
commented 2020-08-28T06:32:28.77+00:00
Monalv-MSFT 5,896 Reputation points
1 answer

Data warehouse features in SQL server versions

Hi, A was comparing SQL server versions and features and i noticed that in versions 2017 and 2016 Data warehouse features there is a feature: -Create cubes without a database …

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-17T11:55:19.783+00:00
Aleksandar Stojanovski 1 Reputation point
commented 2020-08-28T05:53:40.4+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Calculate cost per product per user from budgeted data

Hi, I have a requirement where i have the following data model and unable to arrive a correct measure for calculating cost per product per user.I want to be also able to slice by date and empl dim. Can someone pls correct and post ideas to…

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-17T12:16:35.453+00:00
PV 21 Reputation points
commented 2020-08-28T05:51:57.583+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

mdx issue for multilevel dimension hierarchy

I have a requirement where i had to apply dimension security to one of the dimensions "CompensationItem". But the problem was it has dependency on another dimension "Scenario". We have a mapping table/measure (COMP SECURITY) with…

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-19T09:54:10.52+00:00
sudipta sen 1 Reputation point
commented 2020-08-28T05:50:08.457+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Create folders inside the "Tables" folder

Hello community. I have a model with more than 20 tables and I would like to group them by processes within the folder "Tables", being as follows: Tables > Process A >>> Table 1 >>> Table 2 >>> Table 3 …

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-08-24T22:13:08.213+00:00
Daniel Castillo 1 Reputation point
commented 2020-08-28T04:09:21.493+00:00
PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

File System Error - Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the cube-user database cryptography key.

SSAS DB Synchronization job is scheduled to synch using a XMLA script via SSIS. This synch the SSAS DB 'ESSJMT' from process server ( Source ) to Query Server(Destination). When it failed , server logged below error. And when I tried to run profiler…

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-16T10:36:17.99+00:00
Komal Sahu 311 Reputation points
accepted 2020-08-27T07:55:21.713+00:00
Komal Sahu 311 Reputation points
3 answers

dimension security on a combination of dimensions

0 I have 2 dimension tables scenario and compensation. scenario already has dimension security applied. Now we need to implement dimension security for compensation. Compensation is dependent on scenario. For example we have a separate table which has…

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-05T12:47:44.07+00:00
sudipta sen 1 Reputation point
answered 2020-08-27T01:43:13.493+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer One of the answers was accepted by the question author.

Problems with calculation groups in Power BI connected to SSAS (tabular)

Hi guys,   I'm trying to use calculation groups in Power BI that is connected to SSAS (tabular) but I'm having a few problems.   First problem is processing the calculation group, I'm adding the items in Tabular Editor & VS19 and processing…

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-24T05:02:52.42+00:00
Cameron Wallace 31 Reputation points
accepted 2020-08-25T09:29:59.783+00:00
Cameron Wallace 31 Reputation points
4 answers

Performance Issues SSAS tabular Matrix drill downs

When i drill down in a powerbi report or when i run the extracted Dax query from dax studio i get massive performance hits for certain queries (takes 10-12 seconds). I have tested these queries using a clear cache query and also monitored the Server 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-08-19T09:16:56.347+00:00
Datacrunk 1 Reputation point
commented 2020-08-25T07:01:08.87+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

How to Process Cubes on Different Server?

Hi guys, I am trying to process SSAS cubes on server"B" by kicking SSIS on server"A" with the EffectiveUserName option. The job executing user is an AD user whitch has admin authority on both server "A" 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-08-18T05:50:26.93+00:00
Shohei 1 Reputation point
commented 2020-08-24T06:38:32.937+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

MDX code to get today's date

Hello, I created a query for Excel in Power Pivot using the visual designer. I currently have to change the dates every month. I need to modify it so it automatically returns the data for January from the current year until the current month. …

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-21T14:09:13.197+00:00
L G 1 Reputation point
answered 2020-08-24T05:43:05.687+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

SSAS MDX named set

I am trying to create a common named set with fixed members so it can be used in multiple calculated members. But for some reason, it's failing. I am new to MDX scripting. Let me know if there is an issue here. Aggregate({[TT Collection].[TT…

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-20T11:34:07.953+00:00
Nagrajuna Bandi 1 Reputation point
answered 2020-08-21T02:28:03.203+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

SSAS 2019 Hangs while processing

This has happened four times now since March 2020: I have a SQL Agent job that handles the processing of several SSAS Tabular models. One of the processing steps will hang up. When it does, the SQL Agent Job cannot be STOPPED. Oh, you can try to stop it…

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-19T18:23:20.647+00:00
Todd Chittenden 1 Reputation point
answered 2020-08-20T03:14:20.383+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Dynamic Filtring in mdx Queries

hello... I need to deal with MDX query in SSAS tabular Server... That went almost ok with measures with summation but this is not ok if I decided to work with measures that Deal with Averages.. Since the average calculation is already defined in…

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-17T11:59:47.113+00:00
Radi Soufan 1 Reputation point
commented 2020-08-18T07:59:42.523+00:00
Alexei Stoyanovsky 3,416 Reputation points
2 answers

Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."

I can't enable one of my product add-in due to below error message - Unable to find any Microsoft OLE DB providers on the machine. Please install "Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2008" or later. …

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,202 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
Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
659 questions
asked 2020-08-12T09:04:30.717+00:00
Yu, Xiaoxue (Refinitiv) 1 Reputation point
commented 2020-08-18T03:24:38.253+00:00
m 4,271 Reputation points
1 answer

File for a cloned Vertipaq data object conflicts with a master data object file

Hi, I got the following error after executing the xmla file and starting a MSBI (SSAS) refresh. Does anyone know what this error is about? File for a cloned Vertipaq data object ...... conflicts with a master data object file Any help would be…

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-04T17:03:12.02+00:00
Yao LI 1 Reputation point
answered 2020-08-05T03:14:42.867+00:00
Lukas Yu -MSFT 5,816 Reputation points