SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
0
votes
0answers
165 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 ...
6
votes
3answers
191 views
Find material for improvement in Microsoft BI
Which websites, books etc. can you recommend me to improve my basic knowledge in Microsoft Business Intelligence 2008, SSAS, SSIS and SSRS?
Please remember that I'm a newbie in technical BI tool.
If ...
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?
4
votes
1answer
545 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 ...
2
votes
1answer
847 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 ...
3
votes
1answer
119 views
SQL Calculation based on 'similar' rows within table
I'm using SQL Server 2008 R2, building a fact table for SSAS.
I can therefore accept solutions to this via either SQL query to SSIS task.
Let's say I have a fact table that looks a little like this, ...
1
vote
1answer
312 views
SSAS Modelling - many to many with one dimension
I'm having bit of a hard time modelling an OLAP cube.
My analogy is this: I have a list of students. Each one has one Major subject of study, and zero or more minors, up to five in total.
The raw ...
4
votes
1answer
216 views
Dimension Help - Deciding Fact or Dimension
We have the following Dim and Facts:
Customer Dim: SCD Type 2, Info about the customer ie first purchase date, name, address, etc
Product Dim: SCD Type 2, about our products
Customer Snapshot ...
1
vote
1answer
206 views
SSAS -> MDX -> Create a price comparision against resellers
I want to write an MDX query that will do a price comparison for a product against each re-seller and return a count which a 'greater', 'lesser' or 'equal' for a given month.
Measure:
...
18
votes
2answers
3k views
What does a DBA have to know about SSAS?
I've seen a lot of material covering the business aspect of SSAS, but not really much about the important aspects of administration and management.
From the point of view of administering an instance ...
2
votes
1answer
410 views
Difference between SSAS 2005 and SSAS 2008
I'm asking this question since i'm planning to book a seminar, but the provider told me that they only offer trainings for SSAS 2008 or as individual training which are expensive.
So my question: ...
2
votes
2answers
1k views
Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
We are just starting design for a new data warehouse and we're trying to design how our date and time dimensions will work. We need to be able to support multiple timezones (probably at least GMT, ...
2
votes
1answer
175 views
SSAS Dimension Help - Finding Values Not In the Dimension using Role Playing
I have a Fact / Fact Less table that has a list of Products likley to be purchased by client.
Client ID Product ID
1 1
1 2
2 2
2 5
etc...
I need to to allow ...
1
vote
1answer
82 views
SSAS cell permission
I'm trying to restrict the access to the cube to certain dimension members. I Used the following function on the "Cell Data" tab of the role editor:
[Magatzems].[Codi Magatzem].CURRENTMEMBER = ...
2
votes
3answers
595 views
SQL Analysis Services - SSAS
Do you know what the best practices would be regarding SSAS and having real-time reports.
I am not sure if we should be pulling data off our live database or using SSIS to move data periodically to a ...
0
votes
2answers
393 views
SSAS: Move tempdb database
For sQL server 2008 R2 Analysis services, how can I move tempdb database files from one drive to another. At the time of installation, I didnt the seperate drive for tempdb. Now that I do have one, I ...
1
vote
1answer
424 views
SSAS / MDX Query - Add an extra dimension when using Order
I wish to add an extra dimension to this query, so that I'm able to see the total amount of an item sold, per month/year:
SELECT
NON EMPTY
Order([Item].Children, Measures.[Total Line Value], ...
2
votes
1answer
134 views
MDX misunderstanding: complex FROM clause
I have a MDX query which syntax is familiar to me:
SELECT NON EMPTY { [Measures].[Amount] } ON COLUMNS,
NON EMPTY { ([Projects].[Id].[Id].ALLMEMBERS * [Priorities].[Id].[Id].ALLMEMBERS ) } ...
3
votes
3answers
4k views
SSAS Dimensions Hierarchy causes deployment errors
I've set up a Data Source Connection to the Adventure Works DW database using the services credentials.
I'm creating a dimension using the DimDate table. To simplify things I'm using only the ...
4
votes
2answers
698 views
SSAS queries time out when Windows File System Cache drops
We have a SQL 2008 Analysis Services instance on Windows 2003 that is experiencing near-daily performance issues (query timeouts) during peak activity. A second identical instance queried from the ...
3
votes
1answer
160 views
Connect tables in a cube based on historical data
So this may be the wrong place, and may seem pretty basic, but I'm new to building up cubes, so please forgive me.
Imagine a setup described by the following:
CREATE TABLE [dbo].[Orders] (
...
2
votes
1answer
379 views
Why does an AS cube rebuild use so much TempDB?
I have a 50GB SQL 2008 database (only 36 of that is data) with a 24GB Analysis Server cube that rebuilds nightly.
The cube rebuilds have been using more and more of the TempDB on the SQL server each ...
1
vote
2answers
147 views
SQL Server 2005 datacube processing in high transaction system
We currently have a highly transactional SQL 2005 database which is growning by around 1.2 million rows weekly. On top of this we have a SSAS datacube which is set to process every two hours for ...
6
votes
1answer
688 views
Medians, Modes, Percentiles and OLAP
I'm newbie trying to wrap my head around OLAP, and I have a few questions.
Question 1: Can an OLAP cube store medians, modes, percentiles?
Question 2: Can an user-written MDX query return a summary ...
1
vote
1answer
97 views
Migrating or Synchronizing SSAS Changes
Assume you have 2 SSAS databases, DB1 and DB2, that are identical.
Now they branch off. Changes A and B are made to DB1 and changes C and D are made to DB2.
Is there an easy method to migrate ...
1
vote
1answer
706 views
Does msmdpump.dll pass the authentication info to SSAS?
I'm using msmdpump.dll with basic authentication to access a SSAS OLAP cube from the internet. Does this method pass the auth info to SSAS so if I put permisions on the cube they get applied depending ...
3
votes
2answers
846 views
Connecting to MySQL database from Analysis Services
I need to know whether it is possible or not to get data from a MySQL database and create a Cube in Analysis Services 2008. If so, tell me how to connect to MySQL Database from Analysis Services.
0
votes
1answer
208 views
Using SSAS for retrieval data instead of using SSRS to make a report?
If you work with Reporting service in order to create a report and you need to retrieve data from the relational database.
The datamodel of the relational database can be structured in a certain way ...
3
votes
2answers
384 views
Combining retail sales and payment OLAP cubes
I'm using SQL Server 2005 Standard Edition Analysis Services (SSAS). I'm trying to build cubes from a retail OLTP database that can answer these kinds of questions:
List down all products that were ...
1
vote
1answer
368 views
Boolean field in OLAP cube
What is the best practice for presenting boolean data in an OLAP cube? Should I create a boolean dimension containing two rows, true and false?
1
vote
1answer
447 views
SQL server 2008 Analysis Services DSO properties
We are planning to do Sharepoint and project server 2007 databases migration.
The share point website also processes cubes.
So we will be moving SSAS cubes from SQL 2005 to 2008 and then re-pointing ...
4
votes
2answers
783 views
How do I stop refresh conflicts between Proactive Caching of facts and timed refresh of Dimensions in a SQL Server Analysis Service 2005 OLAP cube?
I have a SSAS 2005 OLAP cube which we've very nearly made into a ROLAP cube using a mixture of proactive caching for the fact partitions and timed refreshes for the dimension data.
There are two fact ...
