Microsoft Q&A

SQL Server Analysis Services

1,171 questions

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.

Browse all SQL Server tags

Filter

Content

No answers or comments

With accepted answer

391

1,171 questions with SQL Server Analysis Services tags

3 answers

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.

asked

David - 0

commented

Luke 25

1 answer

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.

asked

David - 0

commented

PercyTang-MSFT 9,376 Microsoft Vendor

0 answers

Importing data from Excel in SQL

I am trying to import data from Excel into SQL using ETITLE: SQL Server Import and Export Wizard and I got below error: File path contains invalid Excel file. Please provide file with .xls, .xlsx, .xlsm, or .xlsb extension. What can I do to successfully…

asked

vincent Ewere 0

commented

Olaf Helper 33,956

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…

asked

Analyst_SQL 3,266

commented

Analyst_SQL 3,266

1 answer

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.

asked

Lolipooop 20

commented

Lolipooop 20

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…

asked

Robson Mantovani 0

commented

PercyTang-MSFT 9,376 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…

asked

vishnu Reddy 0

commented

PercyTang-MSFT 9,376 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…

asked

Travis Buckingham 1

commented

MARBOUH Soufiane (CANDRIAM) 1

1 answer

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?

asked

r aper 40

accepted

r aper 40

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

asked

Mounika, Durgam 1

answered

AniyaTang-MSFT 9,681 Microsoft Vendor

2 answers

Cases assigned to me

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

asked

Rao, Mayank 20

accepted

Rao, Mayank 20

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…

asked

Shambhu Rai 1,021

commented

Erland Sommarskog 87,761

1 answer

How to fix ---- Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').

i have XMLA script to create the Analysis service database. i try to deploying the script with both primary and secondary server in the AAG environment. i'm facing an issue while running the script - Internal error: An unexpected error occurred (file…

asked

Kaviyarasan J 0

commented

Ross Buttery 0

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

asked

Shambhu Rai 1,021

edited a comment

Shambhu Rai 1,021

1 answer

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?

asked

JK 20

commented

JK 20

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…

asked

Subash Basnayake 51

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…

asked

Osama Abu Asal 1

commented

Antriksh Sharma 0

1 answer

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…

asked

Shambhu Rai 1,021

accepted

Shambhu Rai 1,021

3 answers

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)

asked

L S 20

answered

L S 20

1 answer

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

asked

Peter Dolan 0

answered

Emi Zhang-MSFT 17,066 Microsoft Vendor