SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
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 ...
1
vote
1answer
265 views
Processing occasionally fails with “Unexpected end of file has occurred.”
I've got an Analysis Services database that's used for reporting on email activity. It mainly counts incoming and outgoing messages, who they're to and from, etc.
Fact table: 11,367,910 rows
Address ...
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 ...
1
vote
1answer
313 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 ...
1
vote
2answers
148 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 ...
1
vote
1answer
371 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
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
1answer
515 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, ...
1
vote
1answer
212 views
SSAS - Inferred Dimension Attributes - are they necessary?
I have a cube with fact tables that have a parent-child relationship: Person - Case. Some dimensions are inferred from the parent, e.g. State in the example below. Person does not have a foreign key ...
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 = ...
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:
...
1
vote
1answer
428 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], ...
1
vote
1answer
98 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
712 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 ...
1
vote
1answer
448 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 ...
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 ...
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 ...
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 ...
0
votes
1answer
587 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
1answer
139 views
BI development in Microsoft BI
I need to learn how to create a dimensional modelling for an organisation that do not has a BI tool and BI model.
Where can I learn more about BI development that should be used in a company?
IT's ...
0
votes
2answers
395 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 ...
0
votes
1answer
119 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 ...
0
votes
1answer
210 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 ...
0
votes
2answers
760 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
...
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 ...
0
votes
0answers
33 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 ...
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 ...
0
votes
0answers
102 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
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 ...
-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 ...
-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 ...
-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.
