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,…
Data Source (SSAS database) into SSAS Tabular project
Hello, I am trying to make an aggregated table in my tabular project where the source of this table will also be a table of a tabular model. In summary, what I did was as follows: I created a MS Analysis Services database Data Source with a DAX query…
SSAS DB Synch job hanged - Profiler shows 'Lock Acquired' but no 'Lock released' -where is the problem?
SSAS DB synchronization job (using xmla via ssis) usually takes 30 minutes to complete, but is getting hanged for indefinite time until I terminate it forcefully. Even I terminate it, it do not release physical memory and also can not restart a manual…
New server cube processing timing out because the query wont run parallelism, what do i do?
So I am testing upgrading from 2017 to 2019 and one of the cubes keeps timing out after 1 hour. I have tried changing any timeout options on SSAS from 60 to 180, yet it still fails. The query plan on the previous server uses parallelism yet the new…
Tabular Error in project
Hi, I am currently working on a SSAS tabular model cube. I am getting the below error. Plz someone could help on this ? The size of a data value in table '<#####>' column '<******>' was too large to fit in that column. The current…
SSAS: Server: The current operation was cancelled because another operation in the transaction failed.
Hello, I'm creating dimensions in SSAS and I was successful with the two other dimensions tables but only this one is giving me an error when processing it. the error is Server: The current operation was cancelled because another operation in the…
MDX - filtering measure values
Hi everyone, I created a role in SSAS. I denied the dimension customer data which works fine. But what can i do if i want to denied the cell data (I mean the total measure values) for every customer except the customers with the ID 10000 and 11000? I…
SSIS/SSAS: How to change only the table name without remap the columns, flows and dimensions?
Hi, My company asked me to change the name of some of my SQL Tables( Dimensions ). But the only way that I know to do that is delete the references to the old table and map them again and recreate the OleDBSource/OleDBDestination ( SSIS ) and recreate…
What is the impact of setting ASPaaS\AlwaysUseGateway to false
HI all everybody, this is my first post and I'm here to ask for your help. This is the scenario on my Team: Client - Visual Studio 2019 connecting to AAS deploy using a server of IaaS as data source - issue And they sent me this image…
Multidimensional Project Data Source Wizard Fail SSAS
Hello, I'm trying to create a data cube in Visual Studio (SSDT) and I'm unable to launch Data Source Wizard. When I select New Data Source, I see the wizard, but when I click Next, the wizard dissapears. Has anyone faced such issue? Could this be…
Suppress Zeros and Empty Rows and Columns by using MDX
Hi, following is my MDX. Still getting zero rows and columns. how to remove zero rows and columns. Select Non Empty CrossJoin( CrossJoin( {{[Account].& [1]}, {[Account].& [2]}, {[Account].& [3]}}, {{[Measures].[YTD]}, …