Parameterized SSRS reports sourced from OLAP cube with a dimension having set a default member

Imagine you develop SSRS 2008 reports based on SSAS olap cubes and face the following situation:
a default member on a dimension, let's say the Date dimension.
The report uses a parameter and it's default member is based on it ( typically the last date where the system has a non empty measure).
User picks up the default member for the date dim. and another date - in order to see the aggregated results - but only the results for the default member are displayed.

The relevant part of the query - I do take into account what the designer generates - looks like :
 SELECT NON EMPTY { [Measures.[...] } ON COLUMNS, NON EMPTY
{... } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM FROM ( SELECT ( STRTOSET(@LocalDateCalendar, CONSTRAINED) ) ON COLUMNS FROM [MISDBCC]))
WHERE ( IIF( STRTOSET(@LocalDateCalendar, CONSTRAINED).Count = 1, STRTOSET(@LocalDateCalendar, CONSTRAINED), [Local Date].[Calendar].currentmember )  ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
( I omitted other parameters , etc. )

The query includes both days but the cube retrieves only the results for the default member.
When I eliminate the default member on the dimension the results are right.
My conclusion was : There is a cube// dim. bug and I worked on the following work-around :

Delete the default member for the dimension, create different roles and create the default member only for one role, as I still need it for some reports.
Then use different connections for the reports data sources depending on the roles (Roles= directive).
And last but not least at the report level I created data sets for default member for the Date parameter involved , based on the previous logic for defining the default member at dimension level. ( Tail(Exists (...) construction .

If you were struggling with this kind of issue before or just like to reproduce and investigate it, than I'd like to get your feedback.

Navigate and select from cascading parameters SSRS reports

We all need to share information. That is why we upload strategic reports to Sharepoint to quickly disseminate insightful information across the enterprise.
We implement digital web part pages that display cascading parameters SSRS reports.
But do all users know how to navigate , select in the drop-down list boxes or even print the reports ?
Hope that the following video will help the users:
http://www.youtube.com/watch?v=8wU-kQBER94

Print a report from a Sharepoint Web application

Some of my end users are interested in printing reports from Sharepoint.
I recomended them to use the following step-by-step approach :

• Click on Report Library on the breadcrumb navigation
• Select the report item you want to print from the report library
• Select Actions -> Export on the status line and choose Acrobat( PDF) or Word or another save format.
• Choose Open or Save and use the print features that the program you saved the report provides.

The technical users may perhaps have a look at the Microsoft site :
http://technet.microsoft.com/en-us/library/bb326212(SQL.90).aspx 

Some parameter names not allowed in SSRS 2008 R2

I was suprized to realize that some previous well functioning SSRS reports failed when 'previewed' .
The error sound like : "An error occurred during local report processing. An error has occurred during report processing.Query execution failed for dataset '****'. Parser: The syntax for 'Date' is incorrect.

But the report worked once and as far as I could see nothing has changed behind time. So how can it be ?
It took me a while to realize, that all of a sudden it does not like the parameter name 'Date' , because the syntax around it has never changed. It looked like parameter names like @Date and @Application were not allowed any more. They were treated as reserved keywords.

So the solution was just dummy replacing them - by @Date1 , @Application1 or the like  - in query , parameter list and all the way around where they showed up.
Then I could preview the reports like I did it once.
If you also experienced this or have an idea of the root cause of this issue, please leave me a note.

Cross selling by using data mining

Data mining is often an underestimated part when it comes to BI 

I have uploaded a demo concerning cross selling in financial industry by using data mining: http://www.youtube.com/watch?v=RqHKOuQpdrY

Cube writeback with multiple values in one shot

Writeback ( writing to a cube) from a client application is not a trivial task to implement.

Writing multiple values in one shot can be tricky.  

I made a video showing a SSAS cube writeback application with multiple values at a time: http://www.youtube.com/watch?v=HW9Jqya7OOQ