Stack Exchange Network

Stack Exchange network consists of 175 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

2
votes
1answer
34 views

SSAS Model Refresh - Not enough memory to complete this operation Error

We have started encountering an issue regarding the refresh of our tabular SSAS model. The tabular SSAS model has 38 tables within it. This process has been running without issue for over a year, ...
0
votes
1answer
13 views

Can't create any objects within OLAP database

Problem I can't create any objects under my databases in my Analysis Server. My context menus on all the folders under this test database just have Refresh as an option. Details My Analysis Server ...
0
votes
0answers
32 views

Compare Validate TSQL Data Warehouse to SSAS

How do I compare Data in T-SQL DataWarehouse to SSAS Cube? I would like to conduct this from SSMS (SQL Server Studio Management Studio). Example Select CustomerName from dbo.DimCustomer where ...
1
vote
0answers
32 views

SSAS Find Distinct Business Key Count for Fact Table

We have Dimension Table and Fact Table in SSAS Cube. The DimCustomer table is Slowly changing Dimension, it tells when Business Key eg: 2, Joe Smith, changes his address, phone number. Hence, a ...
0
votes
1answer
30 views

SSAS Build in TFS

How do I build an SSAS Cube Project in TFS? For 1) DatabaseProjects: it is MSBuild 2) SSIS: Devenv.exe with SSIS Project directory How would I build in Team Foundation Server 2015 for SSAS cube? ...
0
votes
1answer
13 views

Tracing tabular refresh errors

I have a tabular cube on an SQL Server 2017. The cube is refreshed with a full refresh command in a Server Agent job. The job runs on a schedule. When I check the history of the job I see that it ...
1
vote
0answers
25 views

SSAS error - invalid attempt to read when reader is closed

I'm trying to run my SSAS project but I got an error. I'm using a MySQL database as my data source. I can connect and build the view, but when I create a dimension and I try to run it get this error:...
0
votes
0answers
24 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
107 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
32 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
37 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
70 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
vote
0answers
71 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
26 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=...
5
votes
2answers
617 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
73 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
74 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
731 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
27 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
164 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
29 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
65 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)? ...
4
votes
2answers
730 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
117 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
139 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
121 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
176 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
158 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
37 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
95 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
673 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', ...
3
votes
2answers
305 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
16 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
974 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
45 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
353 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
178 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
375 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
684 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
381 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
124 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
49 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
74 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
401 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
399 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
77 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 ...