Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ssas]

SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0

0
votes
0answers
14 views

Can't connect to SSAS server — “Element 'return' was not found. Line 5, position 2.”

I'm trying to access an SSAS server from SSMS v17.4 (2017). I'm using Windows Authentication. I know the credentials are correct and can actually connect successfully from Visual Studio 2015. ...
2
votes
1answer
78 views

Processing cube freezes SSAS

We are processing a partition on a cube in latest version of SQL Server 2017 (CU 13, also tried in CU 12 and CU 4) and sometimes it totally freezes. Task manager shows no movement at all - not memory, ...
0
votes
1answer
22 views

DBCC on SSAS Cube fails

DBCC on the Cube fails(SQL version 2014 SP2, 12.0.5000.0). My XMLA query: Error message: Executing the query ... The DBCC element at line 7, column 88 (namespace https://schemas.microsoft.com/...
0
votes
0answers
9 views

mdx tabular 2017 model, calculated member with solve order fails

In tabular 2017 (compatibility level 1400) my query gets this error: Query Error - MdxScript(Model) (3, 38) Calculation error in measure 'Fact Order'[Sum of Quantity]: The expression invokes an ...
1
vote
0answers
24 views

connection to remote Analysis Services from SSMS

On my company local SQL Server instance I was able to add a linked server to a remote AS instance (in Management Studio > Server Objects). I was also able to connect using Data Tools, as well with ...
-1
votes
0answers
10 views

MDX Query Editor Dropping Filter Value

I'm facing a huge issue with SQL Server Analysis Services. I've got a dimension named Report Currency. Whenever I use the Query Designer in any kind of software (Excel PowerPivot, Visual Studio, etc.),...
-1
votes
0answers
45 views

Deploying a Tabular SSAS getting error

I have a developer who is trying to deploy a Tabular SSAS to our SQL Server 2014 server. Our SSAS instance says it is set to server mode tabular, supported compatibility level is 1100 and our version ...
1
vote
0answers
58 views

How to improve performance of SSRS report using Cubes as data source?

I am trying to build an SSRS report with SSAS as the data source. It has 4 cascading parameters. I used the SSRS Query designer to generate MDX because I am not very familiar with Cubes/MDX. It works ...
0
votes
0answers
12 views

How to query SSAS Datasource ConnectionString Properties

I've been asked to audit the Connection strings used by our SSAS OLAP cubes and where they are sourcing data from. I can view the properties manually and can even script them: Provider=...
-1
votes
0answers
14 views

Open query editor of existing queries in SSAS visual studio

It seems like it's too easy to even ask, but for some reason I haven't been able to find the solution anywhere: I've connected tables from an Azure SQL database to SSAS in visual studio, I've done ...
5
votes
2answers
219 views

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

TL;DR I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (...
1
vote
1answer
40 views

how to add an extended events tracking session to SSAS?

I would prefer to have a script to achieve this, but as I am not so familiar with SSAS I am using the wizard to create an extended events session in SSAS. The way I am doing it is right clicking on ...
-1
votes
2answers
62 views

information about licensing and patching SSAS [closed]

I have one server for data warehousing, and it has 2 instances of SSAS (SQL SERVER Analysis Services). The data warehouses are not that big, less that 200GB, and I backup the whole thing on a daily ...
1
vote
1answer
339 views

Can't deploy SSAS Tabular Model in Visual Studio

I am following the SSAS Tabular Model Tutorial by Microsoft using the Adventure Works DW. I've imported the DW in SQL Server Management Studio to my local server. I've connected to the DW from Visual ...
2
votes
0answers
25 views

Query to get Object_ID and Dimension_Name from DMV

I am looking for a DMV query which contain Dimension_Name and Object_ID together. I have System.mdschema_dimensions to get the Dimension Unique name and System.discover_object_activity to get the ...
0
votes
1answer
98 views

SSAS Cube Process Manually works but MDX query doesnt work

I am new to SSAS. Here's a cube which is rebuilt by a SSIS package everyday but it seems to cause duplication. We manually 'Process' the cube using the GUI, it then updates this table with the ...
0
votes
0answers
22 views

ssas-cube-duplicate-cannot-load-model

Issue Primary developer on BI Model (SSAS Cube) can no longer access the model. When they try to open the tabular designer in SSAS they get the following error message. The interesting thing is, when ...
0
votes
0answers
25 views

Slicing a partition by current year, previous year, and two years ago

I have a cube that has partitions of this year, last year, and the year before last. Currently the partitions filter dates using a SQL query, but I'd like to replace that with slices. Ideally, I'd ...
1
vote
0answers
56 views

Proactive caching vs. nightly cube reprocess

I'm working with an SSAS cube that's fully reprocessed every night by an SSIS job. My current goal is to get data into the cube with less latency, and to do so I'm looking at implementing proactive ...
1
vote
1answer
26 views

Preventing SQL Server Data Tools from Inserting Spaces in Object Names

Is there any way to prevent SQL Server Data Tools and Visual Studio from introducing spaces into object names when creating dimensions, mining structures and the like from data source views (DSVs)? ...
3
votes
2answers
488 views

administrator permissions on a SSAS database

I had a third party company coming over and building ssas databases to produce reports. They did, but now the DBA wants to have a look but I haven't got permissions, to even see those databases, as ...
0
votes
0answers
80 views

Can I create a replication table with extra column only on subscription side?

I am having a tricky situation regarding replications in MS SQL server. We are building a SQL Server Analysis Services Cube DB for our new reporting system. This requires to retrieve data from ...
5
votes
0answers
129 views

Using the Schema Generation Wizard to regenerate a previously-generated schema

Lately, I've been trying to clean up a group of projects that my company received from an outside contractor. Among them is an SSAS cube, with an associated data warehouse. The contractors generated ...
4
votes
2answers
109 views

Regenerating a cube relational schema in Visual Studio

I have an Analysis Services cube project that my company received from an outside contractor, and I'm trying to get it so that developers can work on it on their local machines. I'm pretty sure that ...
0
votes
1answer
150 views

SSAS and Visual Studio Optimization Wizard does not work

We have setup and logged data on our Production Server, but when we try to run the Optimizations from within Visual Studio it crashes immediately with TITLE: Microsoft Visual Studio ------------------...
0
votes
0answers
139 views

Can't see Create Database in Analysis Services SQL Server Management Studio

When I right click on Databases in Analysis services there is no Create Database menu Item. Another person with this problem 'reinstalled with all options' but when I run SSDT setup there is only '...
0
votes
1answer
35 views

SSAS Cube Only Displays Total Values

When browsing my cube it shows the correct invoice values by date when I select only a date type (the date table was generated by SSAS with hierarchies), but if I add the customer name it shows the ...
0
votes
0answers
70 views

Process an OLAP Cube as a daily job takes too long using `ProcessFull` option

I have two cubes which updates in sequence. These takes very long to update, upwards of 5 hours due to their sizes. I have a SQL agent job which updates the cubes. The job has type SQL Server ...
1
vote
1answer
517 views

“The attribute cannot be found when processing” error

I'm facing following error while processing SSAS MDX cube: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE_NAME', Column: 'COLUMN_NAME', ...
0
votes
0answers
68 views

Azure Analysis Services Tabular InMemoryWithDirectQuery hybrid mode

Would you be so kind to describe steps to deploy and use the InMemoryWithDirectQuery hybrid mode? I need n partitions in-memory and a single one DirectQuery from SQL Database. I am trying to do it (...
3
votes
2answers
266 views

Equivalent of SQL Not Exists in MDX (or finding another way to accomplish same result)

I am trying to help a contractor implement a cube in Multi-Dimensional SSAS 2017 and do not have very much experience in MDX. I have a table that looks something like this: The goal is to only ...
1
vote
0answers
15 views

Tier Dimension based on measure value

I have a case where i need to have a dimension based on measure value. example : the fact table is linked to date dimension through DateID, and what i want to add is another dimension for Tier, but ...
0
votes
1answer
810 views

How to List all roles and their members (users/groups) of an Azure Analysis Services tabular model/database

I have a tabular model/database in an Azure Analysis Server instance. Model/database has roles and users/groups were added on each role. I can see the list by right click on the role and then go to ...
1
vote
2answers
44 views

Is it ok to install a SSAS 2016 instance next to a SQL Server 2014 instance?

Should I expect any problems installing a SQL Server Analysis Services 2016 tabular instance next to a SQL Server 2014 database engine? (e.g. due to an update of some shared components) I'm mostly ...
0
votes
1answer
320 views

How to dynamically add/remove role members from SSAS 2016 Tabular model

I am developing a number of tabular models, which currently have a limited number of users assigned to roles within each. At the moment, with the exception of 1 or 2 cases, the majority of the users ...
1
vote
2answers
107 views

The 'Database' with 'ID' = 'xxxxxxx' doesn't exist in the collection

I have a SSAS Tabular server with 30 database. I also have a scheduled process to backup all databases daily. When I run the process which is an SSIS package with script task using AMO, I get this ...
0
votes
0answers
21 views

Cannot create Analysis Server from portal

I am starting a course on SSAS, but cannot create a development server in Azure. No matter what I do, the "Server name" box remains red?
2
votes
1answer
327 views

SSAS Date Dimension Relationship In Data Source View

When a fact table is at a higher granularity to the date dimension (e.g. monthly) how should this be represented as a relationship in the data source view? With a date dimension containing columns ...
1
vote
1answer
547 views

Is there a JDBC Driver for Microsoft SSAS Tabular Databases?

Is there a JDBC Driver for Microsoft SSAS Tabular Databases? Is so where can they be downloaded?
1
vote
1answer
300 views

Deploying a cube where database name has been changed

I have an issue where I have renamed the database for which my cube deploys to from, say, SalesAndStuff to Sale. This has been no issue, I have changed the database name in Management Studios etc. ...
3
votes
1answer
120 views

What are the most relevant similarities between T-SQL and MDX?

I have used T-SQL (CTEs, windowed functions, recursive CTEs, large data, table-valued functions, APPLY, PIVOT, stored procedures, etc.), but have never queried a Microsoft SSAS cube. Are there ...
1
vote
1answer
45 views

SSAS Feature to hold confidential data

I need to use Data Cubes to analyse the Sales Performance. Since the product costs are highly confidential it should not be exposed to the middle management. However, the other information needs to be ...
0
votes
1answer
2k views

Class not registered error in SSAS Data Source View

Has anyone come across Class Not Registered issue while opening Data Source Views in SSAS using Visual Studio 2015? There are similar posts not haven't found anything exactly the same. Error text: ...
1
vote
0answers
57 views

Permission error while browsing the Dimension when Dimension Security is defined on one of the attribute

I am using SSAS SQL Server for dimension modelling, and the dimension is defined as below: Dimension Name: Department Dimension Attributes: Location DepartmentCode DepartmentType I have ...
2
votes
1answer
321 views

SSAS Realtime Processing

I created a cube in SSAS, how I can extract real time data from the data source to my cube? I mean if any data modification (insert, update, delete) happens, SSAS should update the cube.
0
votes
1answer
351 views

SSAS Calculated Member Conditional Count

I have a table representing Accidents and a column with Accident Severity ranging from 'Slight' to 'Fatal'. I want to create a measure counting Fatal Accidents depending on other columns on the ...
3
votes
1answer
68 views

SSIS / SSAS: Handling Age Columns

I have some columns representing Age in a table, taking values from 0 to 100, but also -1 for 'Missing Value'. I don't want to store them as strings to be able to find average age etc., but SSAS turns ...
3
votes
1answer
500 views

SSIS - SSAS: Missing data handling

I have a solution in SSDT with a SSIS and a SSAS project, with missing values in both numeric and text columns. Is it a good practice converting all the missing values of these columns to NULL during ...
2
votes
1answer
479 views

SSAS Cube processing randomly fails with 08S01 error

We have a cube which is scheduled to process every morning at 6:00 to run at SSAS 10.50.2500.0. Sometimes it does it ok. More often than not, it fails. When it happens, SQL Server has this entry ...
1
vote
1answer
45 views

MAT over a calculated measure [closed]

We have an OLAP SSAS cube with budget data on the fact table, and budget cathegory (sales, costs, salaries, ...) on a dimension. We have a bunch of formulas for our users but we are not able to create ...