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]}, …
Calcualte Sum(Price) Ignoring one level
I need to create a measure which will group by vendorname and account name and pick max price and sum price at vendor level and account level ignore subaccount level. Create Derived table as shown in excel and do sum of price on derived table …
Update ALl measures using MDX Script in the calculations tab
HI, I updated all measures using MDX Script in the calculations tab SCOPE([Measures].AllMembers); THIS = CASE [Measures].AllMembers WHEN [Measures].[MTD] THEN IIF ([Measures].[MTD] = 0 AND [Measures].[QTD] = 0 AND [Measures].[YTD] = 0, null,…
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
je suis incapable de déployer les packages ssis car je n'ai pas le catalogue ssisdb après plusieurs essais je trouve que l'origine de problème le manque de la fonctionnalité integration services j'ai essayé de modifier l'installation en ajoutant cette…
Data warehouse features in SQL server versions
Hi, A was comparing SQL server versions and features and i noticed that in versions 2017 and 2016 Data warehouse features there is a feature: -Create cubes without a database …
Calculate cost per product per user from budgeted data
Hi, I have a requirement where i have the following data model and unable to arrive a correct measure for calculating cost per product per user.I want to be also able to slice by date and empl dim. Can someone pls correct and post ideas to…
mdx issue for multilevel dimension hierarchy
I have a requirement where i had to apply dimension security to one of the dimensions "CompensationItem". But the problem was it has dependency on another dimension "Scenario". We have a mapping table/measure (COMP SECURITY) with…
Create folders inside the "Tables" folder
Hello community. I have a model with more than 20 tables and I would like to group them by processes within the folder "Tables", being as follows: Tables > Process A >>> Table 1 >>> Table 2 >>> Table 3 …
File System Error - Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the cube-user database cryptography key.
SSAS DB Synchronization job is scheduled to synch using a XMLA script via SSIS. This synch the SSAS DB 'ESSJMT' from process server ( Source ) to Query Server(Destination). When it failed , server logged below error. And when I tried to run profiler…
dimension security on a combination of dimensions
0 I have 2 dimension tables scenario and compensation. scenario already has dimension security applied. Now we need to implement dimension security for compensation. Compensation is dependent on scenario. For example we have a separate table which has…
Problems with calculation groups in Power BI connected to SSAS (tabular)
Hi guys, I'm trying to use calculation groups in Power BI that is connected to SSAS (tabular) but I'm having a few problems. First problem is processing the calculation group, I'm adding the items in Tabular Editor & VS19 and processing…