1,253 questions with SQL Server Analysis Services tags

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

get SSAS server admin information

I need to get SSAS server admin information. I know that can be found in the SSMS UI with the corresponding action. Is there any other way to get them? For example, T-SQL or other statements.

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,253 questions
asked 2023-09-27T09:22:09.0433333+00:00
David - 40 Reputation points
accepted 2023-09-29T05:07:48.7166667+00:00
David - 40 Reputation points
3 answers One of the answers was accepted by the question author.

what is the difference

I learned that there are two query languages, MDX and DAX. I want to ask which features they apply to and what is the difference? Is it correct to add SSAS tag? Please let me know if this is not the correct tag.

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,253 questions
asked 2023-09-28T02:21:01.1566667+00:00
David - 40 Reputation points
accepted 2023-09-29T05:07:13.13+00:00
David - 40 Reputation points
0 answers

Data is get calculate after Opening date

I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be get from #tbl_Account_L_Four and Opening_Value ,if Opening_Date is null then data will get from #tbl_transection table. Secondly Opening_Date if…

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,005 questions
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,845 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,253 questions
asked 2023-09-20T08:25:32.1466667+00:00
Analyst_SQL 3,551 Reputation points
commented 2023-09-27T05:43:52.49+00:00
Analyst_SQL 3,551 Reputation points
1 answer One of the answers was accepted by the question author.

I can't find the process feature in Visual Studio 2022

I can't find the process feature in Visual Studio 2022, it should be in the bar where the red line is.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,741 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,253 questions
asked 2023-09-26T15:42:49.31+00:00
Lolipooop 180 Reputation points
commented 2023-09-26T15:49:01.5933333+00:00
Lolipooop 180 Reputation points
2 answers

Creating a measure ( like not exists for sql )

I would like to ask for your help with a question regarding Analysis Services (tabular). Here at the company, no one has knowledge, and I'm having to manage on my own. I need to create a measure that counts service request rows. These service requests…

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,253 questions
asked 2023-09-12T16:03:54.7133333+00:00
Robson Mantovani 0 Reputation points
commented 2023-09-26T09:02:33.8933333+00:00
PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
1 answer

SSAS service failed to connect after upgrade

Hello, I am getting the below error once i upgrade the SSAS service from 2016 to 2017 Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. The installed server edition allows not more…

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,253 questions
asked 2023-09-06T11:08:07.2533333+00:00
vishnu Reddy 0 Reputation points
commented 2023-09-26T09:01:06.19+00:00
PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
1 answer

Tabular data CUBE Partition takes an hour to process and only has 150K rows...

I have an SSAS Tabular data model I developed with VS. In this cube there are many fact and dimension tables with lots of measures. HOWEVER, there is one fact table that in total has 158 million rows and to process all 158 million rows in this one fact…

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,253 questions
asked 2022-11-10T15:27:30.153+00:00
Travis Buckingham 1 Reputation point
commented 2023-09-22T04:56:30.37+00:00
MARBOUH Soufiane (CANDRIAM) 1 Reputation point
1 answer One of the answers was accepted by the question author.

Hide a level temporarily

Hi. My time dimension has two levels (month and year). Sometimes I just need the year level. How to hide the month level temporarily?

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,253 questions
asked 2023-09-19T01:30:19.35+00:00
r aper 40 Reputation points
accepted 2023-09-21T02:01:33.2266667+00:00
r aper 40 Reputation points
1 answer

how can i find any calculations dervied in ssrs paginated report

Hi !! I am very new to ssrs reports , I have bulk of ssrs paginated reports in web portal , I need to find any calculations dervied in ssrs paginated reports. Can some help me

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,005 questions
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,845 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 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,253 questions
asked 2023-09-20T00:17:07.67+00:00
Mounika, Durgam 1 Reputation point
answered 2023-09-20T06:55:07.2+00:00
AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Cases assigned to me

When we uninstall an unused SQL Server from our environment, is there any technical impact on the server side?

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,005 questions
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,845 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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,253 questions
asked 2023-09-19T07:59:23.8866667+00:00
Rao, Mayank 20 Reputation points
accepted 2023-09-19T16:15:04.33+00:00
Rao, Mayank 20 Reputation points
1 answer

last extracted date and change date

Hi Expert, Have loaded data in table for 2 times in a week without date dimension table or last extracted date ... how will i identify last refresh date and current refresh date in sql server create table emp(employee varchar(23),Age varchar(23),Salary…

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,005 questions
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,845 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 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,253 questions
asked 2023-09-15T21:04:31.4466667+00:00
Shambhu Rai 1,406 Reputation points
commented 2023-09-18T20:30:34.1+00:00
Erland Sommarskog 102.9K Reputation points
3 answers

alternative to store procedure

Hi Expert, do we have any alternative to store procedure while running merge statement where we can use exec or run like exec sp_name can we use view instead of any table to something else Regards

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
46 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,005 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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,253 questions
asked 2023-09-14T13:26:11.2666667+00:00
Shambhu Rai 1,406 Reputation points
edited a comment 2023-09-15T10:25:28.9566667+00:00
Shambhu Rai 1,406 Reputation points
1 answer One of the answers was accepted by the question author.

How to fix this?

Hi. An error was encountered during using ssas. The size of a data value in table '<>' column '<>' was too large to fit in that column. How to fix 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,253 questions
asked 2023-09-13T08:09:58.38+00:00
JK 20 Reputation points
commented 2023-09-15T00:42:03.0833333+00:00
JK 20 Reputation points
0 answers

What version of SSAS support the DAX expressions FIRSTNONBLANKVALUE and LASTNONBLANKVALUE

I am using SSAS 15.0.32.50 and I used FIRSTNONBLANKVALUE and LASTNONBLANKVALUE DAX expressions in my measures. The model gets deployed without an issue but when I try to use these measures I get an error "Expression: Failed to resolve name…

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,253 questions
asked 2023-09-13T14:22:23.0533333+00:00
Subash Basnayake 61 Reputation points
6 answers

Import & DirectQuery mode issue on SSAS cubes

Dears, I'm facing this error when i need to convert default mode from import to direct query , anyone can help me , i can't reach to tmitransaction.inl file! Failed to save modifications to the server. Error returned: 'An unexpected error…

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,253 questions
asked 2020-08-17T09:40:13.103+00:00
Osama Abu Asal 1 Reputation point
commented 2023-09-13T08:32:21.8733333+00:00
Antriksh Sharma 0 Reputation points
1 answer One of the answers was accepted by the question author.

simplified delete statement

Hi Expert, can someone explain me the query below DELETE FROM Sales.SalesPersonQuotaHistory FROM Sales.SalesPersonQuotaHistory AS spqh INNER JOIN Sales.SalesPerson AS sp ON spqh.BusinessEntityID = sp.BusinessEntityID and spqh.date= sp.date and…

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,005 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 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,253 questions
asked 2023-09-12T20:22:57.67+00:00
Shambhu Rai 1,406 Reputation points
accepted 2023-09-12T21:40:05.2466667+00:00
Shambhu Rai 1,406 Reputation points
3 answers One of the answers was accepted by the question author.

Which of them is better?

Hello! I need to do data analysis. I learned that both SQL Server Analysis Services and Power BI have this capability. Which of them is better? (I couldn't find the tag for Power BI)

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,253 questions
asked 2023-09-11T07:44:31.3133333+00:00
L S 20 Reputation points
answered 2023-09-12T07:01:49.18+00:00
L S 20 Reputation points
1 answer

Are there are any plans to support SSAS connector in Excel online?

Are there are any plans to support SSAS connector in Excel online?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,574 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,253 questions
asked 2023-09-08T18:15:18.07+00:00
Peter Dolan 0 Reputation points
answered 2023-09-11T06:36:53.6833333+00:00
Emi Zhang-MSFT 22,796 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SSAS Tabular ODBC connectivity to snowflake

hi folks, we have SSAS Tabular 2019 on prem, and we're trying to source tables from snowflake but getting an error when trying to deploy and process the tables (within VS 2017). Interestingly enough, the ODBC driver (supplied by snowflake) tests out…

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,253 questions
asked 2023-09-05T14:33:06+00:00
Cosmin Ioan 20 Reputation points
accepted 2023-09-08T16:41:56.7366667+00:00
Cosmin Ioan 20 Reputation points
11 answers

Can adomd .net core connect to an SSAS endpoint from Linux?

Hi, I've a C# .Net Core 3.1 application, using the latest adomd .net core client, that successfully connects to an SSAS server and retrieves data when run on a Windows (Win10) platform. I've compiled it as portable, specific with libraries, and specific…

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,253 questions
asked 2021-01-17T23:46:51.343+00:00
Richard Oakham 1 Reputation point
answered 2023-09-07T16:08:36.2866667+00:00
Руслан Черненко 0 Reputation points