SQL Server 2008 R2 Update for Developers Training Kit

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d

SSAS Reporting Action Sharepoint integrated mode

Action Target: Cell

Target Object: All cells

Server name: <servername>/sites/bi

Report Path: _layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/sites/bi/documents/<reportname>.rdl

Parameter Name: <name>

Parameter Value: UrlEscapeFragment([Dim].[MemberName].CurrentMember.UniqueName)

PrevMember

I always forget this syntax to get previous member in MDX

([DimName].[HierarchyName].CurrentMember.PrevMember, [Measures].[MeasureName])

SSAS cube report actions with Parameters

Here is how you do it.

Create the report action in the cube

Servername: <servername>:<port>

Report path: reportserver?http://<servername>/Reports/ReportsLibrary/<reportname&gt;.rdl

Parameter Name: <name>

Parameter Value: UrlEscapeFragment( [Dim].[Attribute].CurrentMember.MEMBER_CAPTION)

This will pass the value as a string.

In the report, create a parameter in the report data area

– General: name, prompt, text, visible

– Available values: none

– Default values: none

In the row groups, group properties, filters, add

– Expression: [Dim] =

– Value: @ParamName

MDX Dashboard Filters

Tired a clicking and adding children to your Dashboard Filters. Use this MDX expression. This will get the ‘All’ member, the District level and its children. What’s great is that it is dynamic, so if another Store gets added to a District it will be updated with the new data.

Descendants([Store].[Geography].[All], [Store].[Geography].[District], SELF_AND_BEFORE)

How To Show the Last Update Date of the SSAS Cube

This rocks. Nice code sample too…

 

http://www.biblogs.com/2008/03/31/how-to-show-the-last-update-date-of-the-ssas-cube/

 

 

SSAS Cube Security

I found an amazing article that walks through how to secure a cube by passing Login ID and setting the Default Member of the secured dimension.

Using UserName to Control Data Access and Default Member in SSAS 2K5

 

 

Attribute Relationships

They will save your butt. Shit rolls downhill.

 

SSAS

Building cubes are cool. Here is a little tidbit on how to display months in a time dimension not alphabetically. Set the following properties to the Month attribute.

• Order by : KEY
• KeyColumn : key (1-12)
• NameColumn: month string

Here is how to currently link to a ProClarity view in BSM using a webpage

http://<servername>/pas/en/src/pscorecard.html?page={<page guid>}