1,258 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.

Question on Dimension Security in SSAS cubes

Dear Team, Looking for help on below technical knowledge. This question is for MSBI - "SQL Server Analysis Server " Is it possible to create a security for entire dimension in "dimension data" tab of "Roles" window. For…

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 2024-02-08T16:43:40.5433333+00:00
Prema Prabhu 20 Reputation points
accepted 2024-06-27T08:21:51.1666667+00:00
Prema Prabhu 20 Reputation points
1 answer One of the answers was accepted by the question author.

Sql join query with total row

Hi , please help create table #temp (LedgerID INT, Amount Decimal(18,3)) insert into #temp (LedgerID,Amount) values (121,100),(121,250),(129,25),(129,200),(158,100),(158,500),(157,250),(157,100),(48625,1000) CREATE TABLE #temp_table ( cid INT, type…

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,164 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
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,589 questions
asked 2024-06-24T07:11:57.31+00:00
Mohamed Farook 161 Reputation points
accepted 2024-06-27T04:39:03.08+00:00
Mohamed Farook 161 Reputation points
0 answers

Analysis Service very slow to connect in SQL Management Studio

Hi all, I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC. Connecting to the SQL Database Engine in SSMS is very fast. However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost…

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,164 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 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow 80 Reputation points
1 answer

How to copy an SSAS cube

Good day, I have a cube in SSAS for one financial period, that I wish to replicate for a new financial period, how can I achieve this? Please assist Many thanks

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 2024-06-11T10:33:17.89+00:00
Zimiso 121 Reputation points
answered 2024-06-22T01:18:05.7+00:00
Greg Low 1,660 Reputation points Microsoft Regional Director
2 answers

SQL Server Agent Job "Process Full in SSAS" throws error without details

We have a Tabular Model deployed in SSAS that worked until three days ago but doesnt anymore. It throws errors when calling full process from a sql server agent job. This is basically the Error Message: Column '' in Table '' contains a duplicate value…

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,164 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 2024-06-14T07:30:56.9033333+00:00
Mentler, André 0 Reputation points
commented 2024-06-14T14:24:42.5966667+00:00
Mentler, André 0 Reputation points
2 answers

unable to convert unique identifier

Hi Team, unable to convert this value as an unique identifier and getting null values SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid

Azure SQL Database
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,164 questions
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
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,589 questions
asked 2024-06-12T07:17:37.1633333+00:00
Vineet S 265 Reputation points
commented 2024-06-13T08:27:50.7633333+00:00
Erland Sommarskog 104.7K Reputation points MVP
2 answers

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image. Compatibility level of the SSAS Tabular…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 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 2024-05-31T06:52:56.3233333+00:00
Aravind K Pachaiyappan 0 Reputation points
edited a comment 2024-06-11T11:51:23.16+00:00
Aravind K Pachaiyappan 0 Reputation points
1 answer

Deploying the tabular cube failed with a timerunot error

Hello everyone, I'm encountering an issue while deploying the cube. It's failing, as shown in the image below. Can anyone help me with this?

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,164 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 2024-05-10T13:51:47.6366667+00:00
Bharath Kumar 5 Reputation points
answered 2024-06-09T10:42:09.4333333+00:00
Greg Low 1,660 Reputation points Microsoft Regional Director
3 answers

Unable to install SQL server

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,164 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,854 questions
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 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.
507 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 2024-06-03T08:19:20.6533333+00:00
Cydrx Malla 0 Reputation points
commented 2024-06-06T03:28:25.09+00:00
MikeyQiaoMSFT-0444 1,505 Reputation points
1 answer

SSAS Dimension Processing: Why use ProcessUpdate when ProcessFull is faster?

I have a question about which processing option should be used for SSAS dimensions. I heard that ProcessFull option is faster than ProcessUpdate, and I found that it is the case. I have a big dimension of a cube, which takes about 90 mins to process…

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 2024-06-04T03:50:47.87+00:00
Norman K. F. Chow 80 Reputation points
commented 2024-06-05T07:18:44.41+00:00
Norman K. F. Chow 80 Reputation points
4 answers

create sp to populate table from one db to another

Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync

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,164 questions
Azure Database for PostgreSQL
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,854 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 2024-05-21T02:56:37.6+00:00
Vineet S 265 Reputation points
commented 2024-06-04T14:28:23.0166667+00:00
ShaktiSingh-MSFT 14,201 Reputation points Microsoft Employee
2 answers

Compiling SSAS, SSRS, and SSIS projects under Build Tools for Visual Studio 2022?

I have a build server using Build Tools for Visual Studio 2022 to compile projects. We have several systems that are currently not using the build server because they use SSAS, SSRS, and SSIS projects. Investigating, it looks like Build Tools does not…

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,854 questions
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
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
190 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
994 questions
asked 2024-05-31T14:54:04.85+00:00
Zarate, Martin 5 Reputation points
answered 2024-06-03T05:54:26.9733333+00:00
ZoeHui-MSFT 34,756 Reputation points
2 answers

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,638 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
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,678 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
answered 2024-05-28T13:30:39.0233333+00:00
Gabriel Roldan 25 Reputation points
3 answers

Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…

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,164 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 2024-05-10T07:45:13.2366667+00:00
Natalia Medrano 0 Reputation points
commented 2024-05-27T06:06:58.99+00:00
MikeyQiaoMSFT-0444 1,505 Reputation points
0 answers

Modelos tabulares no liberan memoria

Buenos dias, paso a consultar por un problema. Tengo varios modelos tabulares, y cada vez que proceso alguna partición, la memoria de mi servidor llega a 85/90%. Una vez terminado el procesamiento, la memoria queda en esos niveles, por lo que si quiero…

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 2024-05-17T11:56:15.51+00:00
Roberto Lavisse 0 Reputation points
1 answer

permissions to refresh a data model in azure analysis services

I am refreshing a data model in Azure Analysis Services using an Azure Function App (C# .NET 6). I am using the Microsoft.AnalysisServices.Tabular package available at https://www.nuget.org/packages/Microsoft.AnalysisServices.NetCore.retail.amd64. When I…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,542 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,561 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 2024-02-19T11:10:09.8366667+00:00
Muhammad Pathan 25 Reputation points
edited the question 2024-05-16T08:35:29.84+00:00
Muhammad Pathan 25 Reputation points
6 answers One of the answers was accepted by the question author.

remove values from string

Hi Expert, how will i remove all the characters from values in sql Create table test1 (id string, details string) insert into test1 values('20kjk','3ddf') Regards

Azure SQL Database
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,164 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,854 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
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,589 questions
asked 2022-08-17T10:50:23.187+00:00
Shambhu Rai 1,406 Reputation points
answered 2024-05-11T10:29:32.2366667+00:00
Ebrahim Bazarjani 5 Reputation points
2 answers One of the answers was accepted by the question author.

Contact Microsoft support

How can i contact Microsoft for direct support for my issue？

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 2024-04-30T15:09:09.4633333+00:00
Jefferson-2765 486 Reputation points
edited an answer 2024-05-10T02:32:12.0066667+00:00
ZoeHui-MSFT 34,756 Reputation points
1 answer

We are using windows 2022 server with SQL 2022, the problem is that after sysprep execute ,sql analysis failed with Error:Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change

After upgrade the image to win22 and sql22. Not able to run bam Analysis service getting error Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException: Errors in the…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,493 questions
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 2024-02-09T08:23:31.9833333+00:00
Kasireddy Alekhya Alekhya (MINDTREE LIMITED) 0 Reputation points
commented 2024-05-02T04:35:23.5833333+00:00
gijs reijn 0 Reputation points
3 answers

Attribute Key cannot be found error when processing the table

Hi All We have a dimension (snowflake), where three tables are related DimEntity, DimUnit and DimProvider. When i process the dimension i am getting the following error Errors in the OLAP storage engine: The attribute key cannot be found when…

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 2021-08-26T15:33:05.247+00:00
Amy Jandreau 61 Reputation points
commented 2024-05-01T14:21:00.7066667+00:00
ALDO FERNANDO TAMARA NOREÑA 0 Reputation points