Is there a way to tell the last date / time a partition was processed? I've lots of SSAS databases, with lots of partitions and the automation is not, but will be independently recording when a partition was processed. Is there an independent way to query and confirm? I've looked @ system.discover_partition_stat and system.discover_...
Is it possible to use our solution's existing authentication mechanism for determining access rights to a MS Analysis services cube? We already have a system that manages usage policies and we would like to avoid duplicating this on the SQL Server. Our authentication system is based on NetSqlAzMan and we could expose it as a web servic...
I have a pending project that may or may not be a good candidate for leveraging SQL Server Analysis Services. The project is based around business metric calculations. Does anyone have some good recommended reading for a crash course in SQL Server Analysis Services that'll let me catch up to speed on what the capabilities and uses are ...
Can anyone recommend a good primer on Analysis Services? Website or book recommendations appreciated ...
Does anyone know how to resolve the issue when presented with the following error message when trying to select a datasource for a report in SQL Server Analysis Services? Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows I...
Am making a cube in SQL Server Analysis Services 2005 and have a question about many to many relationships. I have a many to many relationship between two entities that contains an additional descriptive column as part of the relationship. I understand that I may need to a bridge table to model the relationship but I am not sure where...
I have a number of objects in my SSAS cube, many of which were created to be invisible. For example: CREATE MEMBER CURRENTCUBE.[Measures].[Latency Backcolor] AS CASE WHEN [Average Latency] > [Web Alert] THEN 6384849 WHEN [Average Latency] > [Web Warn] THEN 4577517 ELSE IIF ( [measures].[Query count] > NULL, 14876123, null) END, VI...
I don't usually get involved with MDX if I dont have to, but.... I have a cube with simple fact table linked to a time dimension (with date,month,year columns and so on) and I want to be able for a given day of the month calculate the month to date total for that day. In SQL it would be a doddle, however I'm not sure of how to achieve ...
I have created a calculated measure that computes a weighted ratio for the current balance of all loans that fall into various risk ratings: WITH MEMBER [MEASURES].[Weighted Ratio] AS (Measures.[Current Balance] * [Risk Rating].[Loan Rating Code].CurrentMember.member_value) / ( [Measures].[Current Balance], Ances...
I have the following situation in my cube: Shop A uses calendar Cal1. Their sales month starts Jan 5th. Shop B uses calendar Cal2. Their sales month starts Jan 10th. Shop C...etc Shop calendars can not simply be represented as offsets of a main calendar. They have different working days, public holidays etc. I need to produce a daily...
My team is getting ready to start using SQL Server Analysis Services on our project but none of us have a lot of experience with it. What's a good screencast we can watch to get us started? ...