1,244 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
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,244 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,244 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.
12,732 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,244 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.
572 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,244 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