Performance Point 2010 Security Primer

Sooner or later you will either start using or be dragged into an architectural discussion about Performance Point Services 2010.

The following reference introduces the Sharepoint Security Authorisation Model and contrasts the various server roles in Performance Point 2007 with predefined Sharepoint roles 2010.

Finally, the reference outlines the Sharepoint 2010 permissions that are required to perform the various tasks involved in using Performance Point dashboards and the Dashboard Designer.

http://technet.microsoft.com/en-us/library/ee748591.aspx

Early Adopters Cookbook for SQL Server 2012 and Licensing

If you are looking for SQL 2012 training or application compatibility information for SQL Server 2012  you will find a wealth of information in this early adopter’s cookbook.   Includes links to some of the new and most popular features, as well as links to training kits and the SQL 2012 Training Virtual Machine.

http://social.technet.microsoft.com/wiki/contents/articles/6967.sql-server-2012-early-adoption-cook-book.aspx

Almost eNuf said! … I didn’t find enough information in this Wiki on licensing however – so this datasheet is a good place to start – SQL 2012 Licensing.

SSRS – Putting the Squeeze on Column Header Formatting with Line Breaks

In Excel, you can Control + Enter to manually create a line break in a cell to set the custom line formatting you require.  In SSRS you can do this too, but this relies on the committment of the developer to follow this through consistently.  Additionally add multiple developers across different development teams throughout the organisation, some offsite others onsite, some insourced others outsourced, and you might be looking for an approach that allows more consistency.

Open your report, go into the Report properties and add the following function to the code in the Report Properties Code tab.  What this function does is automatically line split your column header title by replacing any space character with a line break.  This gives you the ability to exert a level of control in a large organisation with multiple developers by embedding this code structure in your SSRS RDL template.

Public Function AddLineBreakBetweenWords(words As String) As String

Dim rsRegEx as System.Text.RegularExpressions.Regex = new System.Text.RegularExpressions.Regex("\s+")

words = rsRegEx.Replace(words, " ")

return words.Replace(" ", vbCrLf).Trim()

End Function

In the expression for the column header you can call the expression like this …

= Code.AddLineBreakBetweenWords(Fields!FieldName.Value & " Retail (000's)")

For the Field value “Footwear” the above expression should format the column header something like this …

Footwear

Retail

(000’s)

Alternatively to configure the function to split on the pipe (i.e. | ) character when space is too senstive, then change the function as follows …

Public Function AddLineBreakBetweenWords(words As String) As String

Dim rsRegEx as System.Text.RegularExpressions.Regex = new System.Text.RegularExpressions.Regex("\s+")

words = rsRegEx.Replace(words, "|")

return words.Replace("|", vbCrLf).Trim()

End Function

Yes this still requires committment from the developer to follow this through however in your SSRS RDL template you can prepopulate the tablix column header expressions with placeholder sample values.

Of course if you have SQL 2008 R2 or higher why not also publish the Tablix as a Report Part.

Reference Kodyaz example.

Happy column header formatting!

SSRS Formatting Tablix Cells Summarised in 000’s

SSRS Tip – To format cells in 000’s select any applicable cells in your tablix, go to properties, and paste the following code in the Format property.

'$'#,0,;('$'#,0,)

Remember to add something to the note of “000’s” to the label of your column header so the report users understand why the numbers look a thousand times smaller 🙂

SSRS Inserting a Tablix into a List Control – Custom Table Heading

Image

You have a requirement to page break a table on a particular grouping…you would like a custom heading for the table but are unable to merge the header cells sufficiently to give you the precise table heading formatting you require.  Create a list control, assign to the same dataset as your table, add a textbox for what will be the table header, configure the grouping for the list that will trigger the page break (don’t set page break options for the list control just set the grouping), then insert your preconfigured tablix (dataset assigned, fields, formatting etc etc) into the list control.

Now format the table header textbox and configure its value as the relevant field from the dataset (which will be the same field you configured for the list grouping), then set your page break options on the tablix you just dragged inside the list (e.g. page break after).

Run the report and you should have a table and table header that repeats on a new page every time the group changes in the list.