SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
-2
votes
0answers
27 views
INNER JOIN for DAX [closed]
If I have two tables to make a inner join (many to many), is it possible to do it by using DAX?
Please remember that duplicate of data row exist in these two tables.
-1
votes
0answers
27 views
DAX's level of Business Logic [closed]
From what I have seen about DAX's ability, is it used for doing advanced business logic to be enable to do advanced calculation in the same level as a C sharp developer?
Would you see that DAX's ...
2
votes
0answers
29 views
How to remove leaf member values?
I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case of one fact table, it relates to the middle level of a three level hierarchy.
When you ...
-1
votes
0answers
34 views
Abot SQL Server's Tabular [closed]
Goal:
The goal is to view if SQL server 2012 tabular and its in-memory ability with can be used in relation to PowerView, Excel and Reporting service at the same time. No different instance shall be ...
0
votes
0answers
32 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
0
votes
0answers
6 views
The 'Data-based filtering for mining models' feature is not included error [duplicate]
The 'Data-based filtering for mining models' feature is not included in SKU Standard 64 bit edition.
I have upgraded to Enteprise Edition but I still get the error.
Why is that ? Is there something ...
0
votes
0answers
21 views
The 'Data-based filtering for mining models' feature is not included
The 'Data-based filtering for mining models' feature is not included in SKU Standard 64 bit edition.
I have upgraded to Enteprise Edition but I still get the error.
Why is that ? Is there ...
3
votes
1answer
67 views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
2
votes
0answers
47 views
Date dimension changes between Test and Production Server
I have a cube deployed into a Test environment and Production environment. I've noticed something strange happen with the date dimension.
When deployed into our test environment, the Date Key comes ...
3
votes
1answer
68 views
Time as a measure
Is it possible to have times as measures in a cube?
We're trying to view employee start times by day, aggregating as an average over time, but even with a No Aggregation measure type I'm getting an ...
1
vote
0answers
100 views
How to aggregate calculated measures involving dimension attributes?
The business case is as follows -
I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
3
votes
1answer
55 views
Analysis service database security at application level
I have got a SSAS Cube, we have written an windows application which would issue MDX queries to access the data from the cube and show it in the reports .
This windows application is a licensed ...
2
votes
1answer
91 views
SSAS Drillthough Limit
There is a limit of 10,000 rows that can be returned for a drillthrough rowset in recent version of SSAS. I'm concerned about the risk of of returning partial results without warning if the selection ...
0
votes
0answers
59 views
How to model Week Commencing / Week Ending scenario
I’m reasonably new to data warehousing and I’m struggling to get a feature of my time dimension working. I’d like to model a Week Commencing and Week Ending type of scenario.
I’ve created a DimTime ...
3
votes
1answer
359 views
How to simplify SSAS deployment from DEV to PRO environment
Here is my issue: In my company, there is a team of developper who creates cubes, dimensions(...) in SSAS in a DEV environment (let's call it SSASDEV). This environment is bounded to a SQL Server ...
2
votes
0answers
14 views
Real-Time SSAS cube status notification [duplicate]
Possible Duplicate:
Real Time SQL Server Analysis Services Cube Processing Report
I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services ...
3
votes
1answer
182 views
How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?
Apparently this feature was available in previous versions but has now been removed.
What are some alternatives?
3
votes
1answer
71 views
Simple filesystem cube
I'm trying to understand cubes so thought I would create a simple datamart to represent my filesystem.
So my question is, if I wanted to create a simple datamart to represent my filesystem, how would ...
4
votes
2answers
255 views
How to balance SQL Server memory with SQL Server Analysis Services memory
We have many systems that have the same configuration
One Server (virtual or physical)
Running SQL Server (SQL) and SQL Server Analysis Server (AS)
multiple cores
16gb RAM
Each night the SQL ...
2
votes
1answer
338 views
Real Time SQL Server Analysis Services Cube Processing Report
I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting Services? I would like to be able to run ...
2
votes
0answers
84 views
Semi-additive measures for other dimensions
I am looking for a way to do semi-additive aggregations on a non-time dimension. The model I am working with is similar to a snapshot inventory warehouse. Specifically I am analyzing processes ...
2
votes
1answer
668 views
Security permission to only read SSAS Cube with Excel
I have an SSAS database set up on a SQL Server 2008 server. I have a Role set up with a group of users that I want to be able to access the Cubes in that database. I set up "Read definition" and ...
0
votes
1answer
117 views
Tabular mode disabled during SSAS installation
I am trying to install SSAS in Tabular Mode. However, i find that the radio button is disabled. I am installing it on a separate instance as well. The regular Multidimensional SSAS had been installed ...
2
votes
0answers
213 views
Finding Microsoft.AnalysisServices.Xmla dll in SQL Server 2008 R2
I'm not able to find Microsoft.AnalysisServices.XMLA.dll that I need to import
using Microsoft.AnalysisServices.Xmla;
I have found some articles and answered questions for SQL Server 2005 and 2012. ...
1
vote
2answers
94 views
How to connect to SQL Server Analysis Server via Management Studio command line
I can connect SQL Server Management Studio to a SQL DB by passing command line parameters like this:
"C:\Program Files (x86)\....\Ssms.exe" -E -S SERVERNAME -d DB_NAME -nosplash
(Obviously -E is ...
1
vote
0answers
39 views
Records are discarded if parent dimension refers to a child record that doesn't exist.
I stumbled upon the following issue in SQL Server Analysis Services (SSAS) When processing a Cube database.
I have a dimension that has sub dimensions, however if the parent record refers to a child ...
2
votes
1answer
82 views
How to handle dimension hierarchies that re-join?
The obvious example is a time dimension where days roll up by day>month>year but also roll up days>weeks>year. BIDS complains about it, but I see no other way to model the situation.
10
votes
1answer
223 views
MDX Query for RANK regardless of hierarchy
I'm hoping to add a calculation to my SSAS Cube (SSAS 2012) that will show the relative rank of whatever the current member is against all other members in that grouper, without specifying the ...
1
vote
0answers
123 views
Configuring SQL Server 2008 R2 Change Data Capture with SSAS
I'm completely new to SQL Server Analysis Servers (SSAS) so you'll have to excuse my ignorance. I've been running through the MSDN SSAS tutorial get a handle on how to use SSAS.
We have SQL Server ...
5
votes
1answer
190 views
How do aggregations work in SSAS?
I understand the concept of pre-aggregating data so that multi dimensional queries perform faster, but the descriptions I've seen of aggregations in SSAS seem to imply that an aggregation only ...
3
votes
1answer
72 views
SQL Server Analysis Services - where do I store user logins?
If I would like to create a Business Intelligence (BI) system using SSAS, with SSRS getting data from the SSAS cube.
Which would be the best possible option to store users' credentials used with ...
0
votes
0answers
101 views
How to design the table and its relationship?
I am having a problem designing a Dim and Fact Table for the following problem.
I want to display my data in PivotGrid as below :
First table shows that if i search a person, anyone related to ...
0
votes
2answers
759 views
How do I design a Dimension and Fact Table from a relational database?
I'm new to using SQL Server 2008 R2 SSAS. I have the following tables in my database, that I wish to model using SQL Server Analysis Services:
Table1
ServiceTypeID | ServiceTypeName
...
3
votes
1answer
168 views
Help on designing SSAS Dim and Fact table
I am having a problem designing a Dim and Fact Table for the following problem.
I have a Pivot Grid with data as below :
USER | RELATED USER | RELATIONSHIP | PHONE NUMBER
...
7
votes
1answer
135 views
Dynamic Dimension Security
I have a cube in SSAS 2012 with about 30 dimensions, one of which is Company.
The Company dimension contains a list of companies, of which there are several hundred in the cube. Our security model ...
2
votes
1answer
219 views
Cube Designer Aggregation Wizard Optimization Zero Percent Every Time
I am pretty new to SSAS.
I have a cube (SSAS 2008 R2) that once had aggregations that has been created using the Aggregation Design wizard. When changing schema a few dimensions, i encountered an ...
14
votes
3answers
954 views
Dynamically Define a Range in a Dimension
I have an issue that i face every time i decide to build a cube, and i haven't found a way to over come it yet.
the issue is how to allow the user to define Range of things automatically without ...
2
votes
0answers
101 views
MDX Block Calculation Optimisation
I have a query I'm trying to optimise. I have read an article here http://web.archive.org/web/20100823233821/http://www.biblogs.com/2008/03/30/optimizing-countfilter-expressions-in-mdx/ about ...
0
votes
2answers
315 views
How to build dimensions from SCD tables
Having the foresight to begin collecting data from our production environment several years ago, I have a table with a following structure-
Part
Status
Startdate
Enddate
I can write a relational ...
1
vote
1answer
513 views
MDX - Sum values greater than then a median calculated measure
I'm relatively new to SSAS / MDX. I have a cube with a calculated field which calculates the Median value for a range of prices.
MEDIAN( [DimItems].[Dim Items Id].CurrentMember.Children, ...
5
votes
1answer
325 views
Custom aggregation for non-leaf level nodes to avoid double counting
I have a fact table with the following columns:
WorkerName
OrderId
NumberOfPackagesPerOrder
Note that neither WorkerName nor OrderId is unique in this fact table.
Multiple users could work on a ...
2
votes
1answer
201 views
Need to filter dimension where two attributes are the same
I've obfuscated the scenario but the general idea still applies, so if the schema seems retarded, it probably is in this example...
Let's say I have a Student dimension, and in it are two attributes ...
0
votes
1answer
578 views
SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
I am working on a new cube. I know that you cannot directly create a relationship between two fact tables (and expect good results).
I am just wondering how to go about doing this I have read ...
0
votes
0answers
166 views
Cube dimension relationships confusion
I'm trying to get my cube working without getting "attribute key not found" errors, but the only way I've found to make it work, is to set up a referenced dimension from Dim_PropertyInfo to ...
4
votes
1answer
549 views
SSAS Cube in Excel - Show only applicable rows with KPI?
I have a cube built in SSAS 2008r2. I'm exposing it for the moment through an excel PivotTable.
I recently added a KPI to the cube, and when I show the KPI in my PivotTable interface it causes ...
6
votes
2answers
167 views
Few Questions about SSAS Cubes
I am newbie to SSAS 2012 and here are my questions:
Can we have measures of complex types (table)?
Is it possible to order the results by a specific measure or attribute?
My cube can be modeled as ...
2
votes
1answer
854 views
SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
Here is an example picture of my layout.
As you can see I have my SCD types present (status/startdate/enddate/businesskey).
My key is a surrogate key that identifies each record.
My problem is ...
14
votes
1answer
732 views
Recalculate Time Dimension in BIDS
I'm using BIDS to create a cube in SSAS 2008 r2.
I used the wizard to create a time dimension. Part of that configuration is selecting a date range.
After creation, I realized that I needed a wider ...
1
vote
1answer
344 views
Can't connect to Analysis Services or Reporting Services on localhost
I'm able to connect to my SQL Server 2008R2 localhost Database Engine and Integration Services.
However, when I try to connect to Analysis Services, it fails with the message: "A connection attempt ...
2
votes
1answer
104 views
SSAS 2000 vs 2008 Cube processing times
I have been told that we can greatly reduce our processing times by rebuilding our 2000 cubes in 2008. I was told the difference is substantial (2hrs down to 20mins).
Is this true? If so, why?
