Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
448 questions
3 answers
One of the answers was accepted by the question author.
Analysis Services Tabular Model excel in sharepoint
I have created an analysis services tabular model. It has a database connection and a couple of excel files as data sources. When syncing the azure analysis services from the portal, the data does not update. It only updates if I publish from visual…
asked 2020-09-16T11:58:48.063+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 62%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Palios, Jason
81
Reputation points
commented 2020-09-27T11:21:33.917+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 81%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Juli Lis
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Hiding part Dimension values from some users
Hi all, We have Tabular model with unit Dimension ( like :Hospital 1, Hospital 2, etc). We want to hide few units(hospitals) from dimension member list to the Users . Rows for all the hospitals will be used for some other Measure calculation so…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 48%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Cube Member ID, Name, and Value
Hello; What is the best way to provide an end user the ability to see view a dimension attribute member by either its Key, Name, or Value at their discretion. I'm using Excel pivot table for the front end to access the SSAS cube. For example for…
asked 2020-09-22T15:42:55.933+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 14.000000000000002%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dave Schmitz
21
Reputation points
accepted 2020-09-23T12:32:46.58+00:00
Dave Schmitz
21
Reputation points
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…
asked 2020-08-19T17:03:53.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 34%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
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…
asked 2020-09-17T07:30:58.713+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 23%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK9%3C/text%3E%3C/svg%3E)
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 34%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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…
asked 2020-09-19T11:04:49.963+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 72%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
CHRISTIAN ANDRES SERNA GAVIRIA
96
Reputation points
answered 2020-09-21T01:42:40.557+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIX%3C/text%3E%3C/svg%3E)
Ian Xue (Shanghai Wicresoft Co., Ltd.)
36,071
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…
asked 2020-09-09T09:03:39.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 14.000000000000002%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
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 …
asked 2020-09-11T04:28:38.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 41%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESI%3C/text%3E%3C/svg%3E)
Shermin Ismail
1
Reputation point
commented 2020-09-18T05:58:47.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
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]…
asked 2020-09-09T16:11:08.353+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 85%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
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…
asked 2020-09-08T06:24:41.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Komal Sahu
311
Reputation points
commented 2020-09-18T03:53:36.197+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,821
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
asked 2020-09-08T13:07:44.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 7.000000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PV
21
Reputation points
commented 2020-09-18T03:52:22.637+00:00
Lukas Yu -MSFT
5,821
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…
asked 2020-09-10T19:27:17.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 52%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Myra
1
Reputation point
commented 2020-09-18T03:47:09.187+00:00
Lukas Yu -MSFT
5,821
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…
asked 2020-09-11T14:17:41.737+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 48%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
datadtata
1
Reputation point
commented 2020-09-18T03:44:47.823+00:00
Lukas Yu -MSFT
5,821
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. …
asked 2020-09-12T16:47:54.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
sudipta sen
1
Reputation point
commented 2020-09-18T03:44:02.027+00:00
Lukas Yu -MSFT
5,821
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.
asked 2020-09-17T14:01:31.937+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Swapnil
216
Reputation points
answered 2020-09-18T03:27:24.013+00:00
Lukas Yu -MSFT
5,821
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 …
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 38%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
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], …
asked 2020-09-10T11:44:45.947+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 22%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Bharath Ram
1
Reputation point
answered 2020-09-17T06:24:36.643+00:00
Lukas Yu -MSFT
5,821
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…
asked 2020-09-11T14:25:53.233+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 8%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
jon strauss
1
Reputation point
answered 2020-09-17T06:01:54.257+00:00
Lukas Yu -MSFT
5,821
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…
asked 2020-09-10T05:15:46.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Prajwal Potula
1
Reputation point
commented 2020-09-16T09:10:57.7+00:00
Itch Sun-MSFT
2,556
Reputation points