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…
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…
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…
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 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…
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 …
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]…
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…
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
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…
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…
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. …
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.
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 …
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], …
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…
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…
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…
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…
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,…