All Questions
28 questions
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 ...
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 ...
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" ...
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 ...
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 ...
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 ...
-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.
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:
...
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 ...
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 ...
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.
...
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 ...
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 [...
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 ...
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 ...
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 ...
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
...
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
...
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 ...
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 ...
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 ...
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 ...
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)...
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->...
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 ...
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.
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 ...
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 ...