Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
1 answer
103 views

SSAS: Error duplicate attribute key in processing Cube Dimension

There's dimension DimTable1 containing in Column1 a lot of duplicate values, NULL values and '' values. Processing the Cube fails with an error: Errors in the OLAP storage engine: A duplicate ...
MaterialGirl's user avatar
0 votes
1 answer
550 views

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 ...
mike1310's user avatar
1 vote
1 answer
236 views

Unable to update dimension relationship of cube (SSAS)

Sorry if this question is just too basic. I edit an ssas cube in Visual Studio, and in the tab "Dimension usage", I would like to add a dimension relationship of type "Regular" ...
AGuyCalledGerald's user avatar
0 votes
1 answer
111 views

Created date dimension unable to slicing through cube

My RDBMS is SQL Sserver, and I'm working on SSAS. Fact: I have a fact called fact date | payment 2014-01-04 00:00:00 |198000.00 2015-01-02 00:00:00 |381400.00 2017-01-01 00:00:00 ...
yuliansen's user avatar
  • 500
1 vote
0 answers
1k views

Multiple Dimensions on one field in Fact Table

I have a fact table containing lines of different types. Based upon each type I have a different dimension table that I need to connect. Is there a solution to this problem without creating different ...
domenikbacker's user avatar
0 votes
1 answer
370 views

How to make a (MDX) calculation in a SSAS cube to get the difference between a value from the current row and a value from the previous row?

I would like to make a calculation to get the difference between the departDate from my current row and the arriveDateNextStop from my previous row. I have a fact table which has multiple columns. The ...
Ceelearn anddo's user avatar
-4 votes
1 answer
45 views

A Few Tips on SSAS Cube and Dimension Development

The following are a few tricks I've found to fix reoccurring issues that don't seem to be fixed from any other question or forum.
Ian's user avatar
  • 71
0 votes
2 answers
3k views

Attribute Key Not Found Error SSAS Cube Rebuild

I am rebuilding my SSAS cube and encountering the following error Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'MyFactTable', Column: 'MyKey', Value: ...
PURWU's user avatar
  • 427
0 votes
0 answers
577 views

SSAS Cube processing error: Invalid Connection String

I am getting this following error: "Severity Code Description Project File Line Suppression State Error OLE DB error: OLE DB or ODBC error: OLE DB provider "SQLNCLI11" for linked ...
Nikhil Laddha's user avatar
0 votes
1 answer
127 views

SSAS not import data from SQL Server for GeoLocation

I have a SQL Server table with GeoLocation. I import data to SSAS and make a cube, but when I create a dimension, there is no data in GeoLocation, the column is empty. Can anybody answer me what is ...
Elwira Sochacka's user avatar
1 vote
1 answer
1k views

How to customize large dimension processing using ProcessAdd in SSAS?

We have a very large dimension in our SSAS. During the incremental run we are using ProcessAdd to process the dimension. This dimension processing is taking 95 % of the total cube processing time. ...
AJ01's user avatar
  • 235
0 votes
1 answer
41 views

SSAS Measure with multi concept

I Use SQL Server Analyse Service and have a sales cube. In first I use role playing dimension in my cube and have about 10 Date Dimension on it. In this step I have two problems. first: usually ...
mehdi lotfi's user avatar
  • 11.5k
0 votes
1 answer
1k views

Create custom hierarchy MDX for dimension

In a cube there's an item dimension. An item - other than an item number - can also have other (numerical) attributes. D_Item Attribute [attrib1] Element1 [70] Element2 [40] Element3 [1] Element4 [...
rasenkantenstein's user avatar
0 votes
1 answer
934 views

how to apply a filter (based on unrelated dimension )on a measure

I have a problem in my SSAS cube: There are two fact tables: OrderFact and PaymentFact, when I filter a date, I want to see payments related to filtered date orders. I designed a cube as follows, but ...
user3577606's user avatar
4 votes
1 answer
1k views

Linking date dimension from two different cubes

I have two cubes Computer Engineering Environmental Science. Both cubes have a same Date dimension. I have two scorecards, each for Computer Engineering and Environmental Science as shown in ...
Merin Nakarmi's user avatar
0 votes
2 answers
5k views

Process dimension and cube via XMLA script ignoring Dimension Key errors

In SSAS, there is an option of ignoring Dimension key errors when we manually process dimension from Visual Studio. But I did not see equivalent of it in XMLA script despite lots of binging and ...
Merin Nakarmi's user avatar
0 votes
1 answer
93 views

HR Transaction Cube SSAS Design

I’ve just hit a major road block with regards to implementing SSAS service for our HR department . The core part would be the transaction cube and the elements are: Employee Transaction Date PayCode ...
Ben S's user avatar
  • 159
0 votes
1 answer
29 views

Forward Unassigned Values in Cube

i have build a Cube in the following way: A Measure Table fact_Prdoduction ---------------- ProductionCost CustomerID PlaningValue and a Dimension: Dim_Customer ------------ CustomerID CustomerName ...
gberisha's user avatar
  • 301
4 votes
1 answer
10k views

creation of dimension and fact table through source tables

I have imported my flatfiles to SQL Server 2012 and created few tables (source tables). I need to build a cube in SSAS. But I need to make "dimension" and "fact" tables it seems with proper PK/FK ...
user2861497's user avatar
0 votes
2 answers
1k views

Can we use the cube without deploying?

I am new to SSAS and I have created an analysis services project but I don't have premission to deploy the solution on server. So, My question is Can we use cube data without deploying the solution ...
Jagz S's user avatar
  • 907
8 votes
2 answers
5k views

SSAS 2012 cube browser- how can I create columns from dimensions?

I am new to SSAS, and have created a cube in SSAS 2012. When I browse the cube, I can easily at my dimensions as rows, but how do I add them as columns? In previous versions (I have access to a Cube ...
Lock's user avatar
  • 5,522
2 votes
1 answer
2k views

SSAS -> Age of a person -> Attribute or Measure or both?

Currently, having a discussion with coworkers on whether or not age is an attribute or dimension or both? We are unable to come to an agreement on this, as age could be used as a category attribute ...
Bill Blankenship's user avatar
0 votes
4 answers
8k views

Check if level in any dimension hierarchy is [Foo]

In my Date Dimension I have 2 hierarchies: [Year - Week - Date] and [Year - Month - Date] I want to check in a Cube Calculation if the current level of the Date Dimension is [Date] (the lowest level)...
Thomas Stock's user avatar
  • 11.2k
6 votes
1 answer
7k views

SQL Analysis Services OLAP TIME dimension

Hi i'm struggling with adding time dimension to OLAP cube. I can get everything in cube to work except date. In my source data view I have datetime column. I go by using Dimensions->New Dimension->...
Pavel's user avatar
  • 413
2 votes
1 answer
180 views

Cube Design Question - SQL Server

We have about 10-15 dimension tables that reflect different levels of granularity and about 15-20 metrics we want to track. Does it make more sense to build one cube at the most granular level and ...
Chris's user avatar
  • 23
4 votes
1 answer
4k views

SSAS: change boolean to 'yes' or 'no'

i'm new to Analysis Services. I have created a dimension on a boolean column. Now users want to have 'yes' and 'no' instead of 'true' and 'false' as result. Thanks.
Tim Schmelter's user avatar
2 votes
1 answer
2k views

MDX: use dimension values on columns

I wanted to use dimension properties on columns. So, in the mdx query, I dragged in those properties from the dimension "member properties". But, for some reason, the values for those properties are ...
whizzing_hornet's user avatar
2 votes
2 answers
2k views

Cube Calculated Member Question

I'm rather new to SSAS and am completely stumped on how to solve this problem. I have a dimension called Thresholds. Within the Thresholds dimension there are the following Members: [Threshold ...
Tom's user avatar
  • 53