learn SSAS 2008
Can you provide me the tutorial for SSAS 2008 which also includes learning MDX queries also ? ...
ssas
Aggregation of recursive day-level calculations
I'm trying to set up a cube calculation. My current remit is that I will receive exchange rates, and these will be sent at the start of the month. Sometimes they will change during the month, and I will receive a rate to use for that currency onwards. The initial problem is that LastNonEmpty uses the granularity questioned, which means ...
SSAS cube creation question - parent/child relationship
I'm currently struggling with the creation of a cube. Below is a simplified version of my relational data... Race Id Type Total 1 A 3 2 A 2 Result Id RaceId Gender Position 1 1 M 2 2 1 M 3 3 1 F 1 4 2 F 2 5 2 F 1 In some...
Restricted Access to analysis services
What is the equivalent of RESTRICTED_USER database state in Analysis services? When we try to process OLAP cubes, it fails because of active user connections to teh cubes. Is there a way to restrict the user access to analysis services only to database administrators like we do in SQL server. ...
Visual Studio messed up my .partitions File in a SSAS Project, how to fix ?
Suddenly I can't process a SSAS project anymore. The error I get is 'x.partitions' is not valid and cannot be opened. Check the 'x.partitions' file Last thing I remember was a checkin of the project into TFS. A good idea to fix this would be very much appreciated. The Cube that is causing the problem is a cube with 2 linked cubes in i...
If I used views for my SSAS DSV, can the relationships in SSAS Data Source View be scripted?
I based an SSAS 2005 cube on a data source view comprised of views in the relational layer, nto tables with relationships. I did not use schema binding on the views. Now I need to rebuild two projects from these, but dread having to connect the views' facts and dims all over again in the dsv. Is there script that will reestablish or reme...
How to prevent SSAS to unload from RAM, how to speed up first request
Hi, I am fairly new to SSAS and SQL Server but Google didn't help. I am grateful for pointers to the right documentation. I have setup a cube and I query it from Excel using pivot tables. The very first update/request I run takes around 10 secs to run, however the following request complete in less then a second. When I wait a while ...
sample MDX queries
Can you provide me tutorial for writing MDX and sample MDX queries especially, since I have not been used to MDX ? ...
How do I sort an Excel 2010 pivot table based on a subset of the data it contains?
Hi, I have an Excel 2010 pivot table that has categories and a count measure as the data. Those categories then have a date dimension nested underneath, filtered to show only the last two months. When I sort the categories, I am sorting them by the total of the count measure across both June and July, in descending order. Can anyone ...
Sql Server Analysis Services Parent Child with non-unique key
I'm currently building our Data Warehouse, primarily using Ralph Kimball's methods and guidance. We are using the Microsoft stack for this (so SSIS, SSAS). I am a bit stuck deciding how to handle BOMS (Bill of Materials) which is effectively an unbalanced hierarchy. The BOM handles assemblies which are a collection of parts. Each part...
Sql Analysis Services Current Date
I need to perform a calculation in SSAS which only applies to the current and future months (it can't be applied retrospectively using the available data). I can do this by using the calendar hierarchy and hard coding today's month as follows... SCOPE([Measures].[RollingStock]); ([Dim Date].[Calendar].[Month].&[201008]:NULL...
MDX query issue
In analysis services, I have cube that is based on hospitalization data. For each hospitalization there are potentially 9 icd codes and these are each stored in their own field in the view on which the cube is based. These are stored in a child table in the relational database on which the SSAS database is based. I would like to query...
Case-Sensitive Logical Key in DSV
How do you create case sensitive logical key in DSV , usign SSAS 2008 R2 ...
SSAS 2008 Date in Compound Key
I'm trying to design a cube in SSAS 2008 for data whose base unit is Member-Month, meaning that for each member there is demographic data, certain other indicators that may change, and dollar amounts paid per month. I feel like I need to include MemberID and MonthKey in the same dimension, but this seems like the wrong approach in the ca...
From VSS to Subversion - things to watch out for
We have a SSIS, SSRS and SSAS code repository in VSS that we are moving to Subversion. We have made the sane choice of keeping history in VSS and are making it read-only. I am going to download my entire structure, make it writable, remove all VSS files and VSS info from the Solution and Project files, and then import it into Subversio...
SSAS: change boolean to 'yes' or 'no'
Hello, 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. ...
problem with calculated measure
Hi i had a calculated dimension named employeeretirement based on the dateofbirth of the employee it will display the retirement year.My problem is when i changed the dateofbirths of the employees in the database and processed the cube the changes are not reflecting the browser window.So to solve that im deleting the dimension and addin...
SSAS database backup fails with the error 3239837698
When I run XMLA query to backup SSAS database <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" Transaction="false" > <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>MyDB</DatabaseID> </Object> <File>D:\SSAS\OLAP\Backup\MyDB.abf</File> <All...
Sequential and Parallel process order
What is the difference between Sequential and Paralle Process Order in Analysis Services Process Task, in SSIS ? ...
msmdpump to SSAS
Hi, I have got msmdpump.dll set up on a windows 7 machine pointing to an SSAS instance on another server and every request I send is being logged in the event viewer with the following error. Event ID: 10 Qualifiers: 16653 Message: Message-handling subsystem: The message manager for the default locale cannot be foun...