1,248 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
3 answers

Different Measures calculation according to Client/Date

Hi all!! I'm new to SSAS Tabular Mode and DAX and I was wondering if anyone could help me, please. I have to create a Measure that uses different formulas accordingly to the Client and Date dimensions. For instance, I have a Measure named…

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,248 questions
asked 2020-08-19T17:03:53.26+00:00
Henrique Lima 1 Reputation point
answered 2020-09-23T00:47:09.873+00:00
Henrique Lima 1 Reputation point
4 answers

SSAS database backup

I tried to backup SSAS databases (2008 R2) by using query in SSMS, but it is overwriting previous day's backup. How to take backup without overwriting previous backup. I need to maintain at least 7 days of backup. Currently I schedule a job in SQL Server…

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,248 questions
asked 2020-09-17T07:30:58.713+00:00
kumar-9444 121 Reputation points
answered 2020-09-21T01:53:32.163+00:00
m 4,271 Reputation points
9 answers

MDX query from SSAS change type

Hi All, I have one MDX query and It takes the data directly from SSAS. The problem is that some of the measures are coming as string but not as a number like they are in the SSAS. I want to change the data type or something else. Now Im trying to use…

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,248 questions
asked 2020-09-15T06:44:41.743+00:00
Dimitar 1 Reputation point
answered 2020-09-21T01:52:18.403+00:00
m 4,271 Reputation points
2 answers One of the answers was accepted by the question author.

SINTAXIS MAL ESCRITA FUNCION SELECTEDVALUE(<columnName>[, <alternateResult>])

¿Por que la funcion SELECTEDVALUE esta escrita : SELECTEDVALUE(<columnName>[, <alternateResult>]) ; deberia ser : SELECTEDVALUE(<columnName>,[ <alternateResult>] , el corchete esta dentro del primer termino y deberia estar dentro…

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,248 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,397 questions
asked 2020-09-19T11:04:49.963+00:00
CHRISTIAN ANDRES SERNA GAVIRIA 96 Reputation points
answered 2020-09-21T01:42:40.557+00:00
Ian Xue (Shanghai Wicresoft Co., Ltd.) 30,861 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SQL SERVER Tabular Model - Bi-directtional filter suggestions

Hello All, We have a requirement to show values from all dimension on Row Level Security implemented on particular dimension based Fact Table Join . Lets say we have Fact table which is connected with 3 dimension ( dimA, dimB, dimC) if row level…

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,248 questions
asked 2020-09-09T09:03:39.22+00:00
Ravi Moorthy-Naganathan 21 Reputation points
commented 2020-09-18T12:06:59.413+00:00
Ravi Moorthy-Naganathan 21 Reputation points
2 answers

SSAS HTTP Connection-msmdpump.dll

Hi, I am connecting to an SSAS server from IIS using HTTP connection(msmdpump.dll). I follow the steps mentioned in this link …

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,248 questions
asked 2020-09-11T04:28:38.16+00:00
Shermin Ismail 1 Reputation point
commented 2020-09-18T05:58:47.29+00:00
Darren Gosbell 2,376 Reputation points
2 answers

MDX DYNAMIC CASE STATEMENT Using Perameter

I tried to build dynamic MDX case statement using Parameter, but it shows blank results. can anyone help to resolve this issue? WITH MEMBER ContinentRollUP AS CASE WHEN [DIM_JOB_BILLING_TYPE_V].[GLJC_TYPE]…

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,248 questions
asked 2020-09-09T16:11:08.353+00:00
sudhakar yeta 1 Reputation point
answered 2020-09-18T05:57:19.007+00:00
Darren Gosbell 2,376 Reputation points
1 answer

Synchronization job failed when service MSSQLServerOLAPService crashed -[ Task category 256, event ID 22 ] -- File system error: the process can not access the file beacuse it is being used by the another process <file path>

Hi All, SSAS DB synchronization failed with error: "Synchronization Database Error: The connection eiter timed out or was lost" When checked MSSQLServerOLAPService service was stopped and it logged below error in application log(event…

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,248 questions
asked 2020-09-08T06:24:41.39+00:00
Komal Sahu 311 Reputation points
commented 2020-09-18T03:53:36.197+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

MDX query to get max date on a range

Hi, I want to query the tabular model to get 1st date and last date of first month of current quarter and then find the max of snaphot date that lies in that range.Can you pls help with the query Date column =SnapshotDate Measure= OrderQty

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,248 questions
asked 2020-09-08T13:07:44.24+00:00
PV 21 Reputation points
commented 2020-09-18T03:52:22.637+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

Intellisense in Power Query Not Working

I've been working to setup some reports using Power Query by CUBE functions. It's been very convenience to setup just by typing the double quotes (") to begin a CUBE formula and MS Intellisense automatically display a drop down list of all 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,248 questions
asked 2020-09-10T19:27:17.81+00:00
Myra 1 Reputation point
commented 2020-09-18T03:47:09.187+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

MDX latest product by data greater than 0

i am trying to run an mdx for the latest date per product but at the moment it is giving latest date but our latest date is always a 0, it is normally the day previous that has latest values. Is there a way i can get my mdx to say latest date greater…

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,248 questions
asked 2020-09-11T14:17:41.737+00:00
datadtata 1 Reputation point
commented 2020-09-18T03:44:47.823+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Add measure security for a role in SSAS

I need to add measure security programmatically in Saas. I can do it manually by going to the role and then navigating to measures dimension and add/deny access to individual measures. But how do I access these classes and methods through code. …

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,248 questions
asked 2020-09-12T16:47:54.407+00:00
sudipta sen 1 Reputation point
commented 2020-09-18T03:44:02.027+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers One of the answers was accepted by the question author.

Power BI to AAS connection issue

While I am trying to connect a Tabular Project(designed in SSAS) on Azure Portal through Power BI i get attached error. The data base whici Project in connected is fine runs well on my machine.

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,248 questions
asked 2020-09-17T14:01:31.937+00:00
Swapnil 216 Reputation points
answered 2020-09-18T03:27:24.013+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers One of the answers was accepted by the question author.

Dimension.All.Member much slower than Dimension.Member

Hi - i have a huge dimension (~10 mio entries) where a 3rd party tool is accessing with WITH MEMBER [Measures].[x] AS '1', SELECT {[Measures].[x]} ON COLUMNS, Hierarchize({[Y].[All].[A], [Y].[All].[B], ... [Y].[All].[F]}) ON ROWS …

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,248 questions
asked 2020-09-14T17:29:21.98+00:00
Werner 21 Reputation points
answered 2020-09-17T11:02:12.747+00:00
Werner 21 Reputation points
3 answers

Issue while creating offline cubes in SSAS

Hello All , Am using the below query to build the offline cube but it is failing saying operation is cancelled and no detailed error. CREATE GLOBAL CUBE [Test] STORAGE 'E:\abc.cub' FROM [Cube] ( MEASURE [Cube].[Unit], MEASURE [Cube].[Value], …

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,248 questions
asked 2020-09-10T11:44:45.947+00:00
Bharath Ram 1 Reputation point
answered 2020-09-17T06:24:36.643+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers

SSAS MOLAP. How to change dsv source of cube dimension

Hello there. SSAS MOLAP question. I originally created a single date table in the dsv and derived multiple role playing date cube dimensions from this. Works fine but then i found out from the business that each date dimension needs a different…

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,248 questions
asked 2020-09-11T14:25:53.233+00:00
jon strauss 1 Reputation point
answered 2020-09-17T06:01:54.257+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Cube browsing in excel

HI, I am browsing the cube from excel. I pulled few attributes into filters. in another tab, I got all attributes listed. my requirement is, Capture all filter values from first tab and fill it in second tab. for ex. in the first pic, I browsed cube…

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,248 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,653 questions
asked 2020-09-10T05:15:46.41+00:00
Prajwal Potula 1 Reputation point
commented 2020-09-16T09:10:57.7+00:00
Itch Sun-MSFT 2,556 Reputation points
4 answers One of the answers was accepted by the question author.

OLE DB error: OLE DB or ODBC error: Incorrect syntax near the keyword 'JOIN'.; 42000

Our cubes were working fine and were processed daily in SSMS until some Microsoft security updates were installed & the server was restarted. We receive the error message above when processing the cubes and dimensions. We already deleted the security…

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,850 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,248 questions
asked 2020-09-09T06:21:26.407+00:00
Paler, Flavius 96 Reputation points
accepted 2020-09-15T08:23:28.84+00:00
Paler, Flavius 96 Reputation points
1 answer One of the answers was accepted by the question author.

Hide Some Members in a Time Dimension

My time dimension has WEEKS MONTH and YEAR levels.There are some calculated members that my customer wants to see in the YEAR level. Is there a way of hiding theses calculated members for WEEKS or MONTH level, and show only for YEAR level? Can MDX…

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,248 questions
asked 2020-09-08T05:39:31.053+00:00
KamiFen 121 Reputation points
accepted 2020-09-11T05:59:28.1+00:00
KamiFen 121 Reputation points
1 answer

Calculating percent chagne over time, based on first value

Hello, I'm trying to create a percent increase measure over time. So basically I've got items that have amounts tied to them and dates the transactions happened example data Item: 004502, Amount: 10, Date: 1/1/2020 Item: 004502, Amount: 15,…

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,248 questions
asked 2020-09-04T20:21:05.627+00:00
Jacob 61 Reputation points
commented 2020-09-10T06:53:49.743+00:00
Lukas Yu -MSFT 5,816 Reputation points