1,256 questions with SQL Server Analysis Services tags

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

Connection to Excel , protect password or access to a table only

Hi, I have an olap & tabular cube but the request has become to operational with user wanting to view so many records, now im thinking of a view in excel But how do i hide the credentials from user or can i create a group that can only access 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,256 questions
asked 2020-11-01T12:18:15.557+00:00
IC IC 236 Reputation points
answered 2020-11-04T07:45:26.09+00:00
IC IC 236 Reputation points
3 answers

SSAS Tabular Data Sources and Deploying

Hi Looking for any info... I am using VS 2019 to create a tabular model in a Development domain. I am deploying to a "Test" domain by handing off my files from the BIN folder (after a build) to the dba. Not sure what method this is…

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,256 questions
asked 2020-10-27T16:20:31.51+00:00
Computer Mike 86 Reputation points
commented 2020-10-30T07:33:44.343+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Controlling RLS to tables in a Tabular Model

Hi, I have a current implementation more similar to attached image. I am controlling RLS from User Table to Table A with DAX in Roles. And then RLS automatically flows from Table A to Table B and Table C as its one to one and one to many…

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,256 questions
asked 2020-10-22T17:19:04.573+00:00
manoj alapati 1 Reputation point
commented 2020-10-30T07:02:26.597+00:00
Lukas Yu -MSFT 5,816 Reputation points
9 answers

SSRS Breadcrumb not displaying

Hi, When I am adding number of report is master list and navigating to the report Breadcrumb is not changing in ssrs 2017 example: master list-report1,report2,repor3 when click on the report breadcrumb is not showing the report path.it only shots report…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 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,256 questions
asked 2020-10-21T18:14:49.563+00:00
Shri 21 Reputation points
commented 2020-10-29T06:41:52.937+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

XmlReader for CellSet throws exception with version 14+ of AdomdClient.dll

We use Microsoft.AnalysisServices.AdomdClient.dll version 14+ (works fine with 13), we execute cmd.ExecuteXmlReader, read the xml, then place it into another xmlreader, then load it into cellset (the code below). Works fine with most queries,…

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,256 questions
asked 2020-10-14T09:55:57.82+00:00
Kobi Averbuch 1 Reputation point
commented 2020-10-27T07:16:20.237+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer One of the answers was accepted by the question author.

SSRS new column condition

Hello All, I have a SSRS report where I need to show a new expression called Region If CountryName = Dubai,Kuwait,Iran,Iraq then I need to show Region as 'MiddleEast' If CountryName= Nigeria,Egypt,Ethiopia then I need to show Region as 'Africa' If…

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,256 questions
asked 2020-10-26T16:13:32.63+00:00
Learner 226 Reputation points
accepted 2020-10-27T04:18:56.24+00:00
Learner 226 Reputation points
2 answers One of the answers was accepted by the question author.

How To get cube dimension in ssas 2008r2

How To get number of dimensions from each cube in ssas 2008r2 thorugh MDX query?

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,256 questions
asked 2020-09-15T15:09:14.347+00:00
kumar-9444 121 Reputation points
accepted 2020-10-27T02:28:39.033+00:00
kumar-9444 121 Reputation points
3 answers

Creating a Power bI report from more than a SSAS Tabular DQ models

Hi Experts, Is it possible to create a Power BI report from more than 1 SSAS Tabular DQ models ? If yes please let me know the steps. Thanks Swapnil

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,256 questions
asked 2020-10-20T20:15:42.327+00:00
Swapnil 216 Reputation points
commented 2020-10-23T07:16:25.113+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers One of the answers was accepted by the question author.

SSAS in SQL Server 2014 can be upgraded to SSAS in SQL Server 2019?

Hi All, I have to assess the possibility of SSAS upgradation from SQL Server 2014 Enterprise Core to SQL Server 2019 Enterprise Edition. Request you to please share the guidelines from Microsoft if any on different features added/not…

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,058 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,256 questions
asked 2020-10-21T13:16:25.453+00:00
Komal Sahu 311 Reputation points
answered 2020-10-22T15:02:15.19+00:00
Komal Sahu 311 Reputation points
3 answers

MdxScript(Model) Calculation error in measure

Hi I am receiving this error when I try to create a Table visual in PowerBI Desktop. MdxScript(Model) (186, 59) Calculation error in measure...The result of a conversion or arithmetic operation is either too large or too small. - see below for…

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,058 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,256 questions
asked 2020-10-16T10:59:42.443+00:00
Anonymous
answered 2020-10-22T01:15:44.38+00:00
m 4,271 Reputation points
2 answers One of the answers was accepted by the question author.

How to oraganize columns from 2 tables in 1 folder in SSAS Tabular Model

Hi All, I have 2 table sin Table 1 with 5 columns and Table 2 with 4 columns. Now I wanted to have all the columns form table1 and table 2 to display in 1 folder /subfolders in Tabular Model Display Folder property would make sure to display under…

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,256 questions
asked 2020-10-08T15:50:23.38+00:00
Swapnil 216 Reputation points
accepted 2020-10-20T20:14:24.953+00:00
Swapnil 216 Reputation points
2 answers One of the answers was accepted by the question author.

SSAS Tabular - Perspectives

Hi all, We're an ISV and have a generic multidimensional cube which we're currently converting to tabular. By generic I mean we offer one standard "BI module" that can be deployed without any customisation - it tries to cover most of 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,256 questions
asked 2020-10-19T04:10:31.217+00:00
Clayton 21 Reputation points
accepted 2020-10-19T23:55:12.527+00:00
Clayton 21 Reputation points
8 answers

SSAS Other Presentation Tool

Hi, I have a sql enterprise 2014 with SSIS, SSAS, SSAS Tabular & Powerbi Powerbi is used more for gaphical view of cubes, with olap presnted in excel Mostly finance users so they love their excel but i have other business units who would like…

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,256 questions
asked 2020-10-15T07:54:41.203+00:00
IC IC 236 Reputation points
answered 2020-10-19T03:34:03.317+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers One of the answers was accepted by the question author.

Offline OLAP Cube export from Excel fails with message 'This Analysis Feature is not available with database compatibility 1200 or higher'

I have a pivot table in excel which is connected to a local instance of Microsoft Analysis Server. I would like the table to be accessible offline, so I can send the workbook to colleagues. I tried exporting the data as an offline OLAP Cube (Pivot…

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,256 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,669 questions
asked 2020-10-15T14:30:17.117+00:00
Alan Freeman 151 Reputation points
answered 2020-10-16T12:36:28.36+00:00
Alan Freeman 151 Reputation points
3 answers One of the answers was accepted by the question author.

Update Tabular model when new column added to table or view

Hi I have added a new column to the SQL server database source (a view), but when I reprocess affected table in Visual Studio it does not appear available for inclusion in Power Query editor or otherwise. When I import the same affected table…

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,058 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,256 questions
asked 2020-10-12T13:23:54.1+00:00
Anonymous
answered 2020-10-16T10:22:04.05+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

MDX Topcount with positive and negative values

Hello, I have a measure that can be positive or negative independs on my report filter. When my measure>0 then i select the top 5 in this case i don't have problem but when mymeasure <=0 i want to select in first the negatif value then 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,256 questions
asked 2020-10-15T19:41:57.077+00:00
Yassir 201 Reputation points
accepted 2020-10-16T08:15:14.5+00:00
Yassir 201 Reputation points
4 answers

Problems in Calculation groups with SSAS

I have created calculation groups viz. Current, Prev Day, Growth, Growth%. I am facing the following problems: I am unable to get grand totals for the Prev Day column. Hence when you look at Growth, it gives an incorrect figure which is…

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,058 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,256 questions
asked 2020-10-05T08:42:36.48+00:00
Rajeev Shah 1 Reputation point
commented 2020-10-16T08:04:18.397+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

What is best way to use ssas?

Hi, SSAS comes along with sql server , so we dont need to pay extra fee for SSAS outside our SQL Server? I googled and I find azure AS is also have same function, what is the difference between azure as and SSAS?

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,256 questions
asked 2020-10-14T06:50:35.4+00:00
Cassandra 41 Reputation points
commented 2020-10-16T07:35:28.497+00:00
Lukas Yu -MSFT 5,816 Reputation points
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,256 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,256 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