SharePoint, .Net, SQL, MS BI, Collaboration and Gadgets

Since I am still new to SQL reporting services, I thought changing charts/pie color is impossible. The VS editor seems doesn’t have any more setting for me to do so. As you all know, the default palette color is very ugly. Luckily, I manage to found one article describe how to get more out of these limitations.�
http://msdn2.microsoft.com/en-us/library/aa964128.aspx

This document describes how to customize your charts/pie. Here is my before-after outcome:

Before

After�

It is not hard, just extra some codes. Do make it to make your client happier! Cheers!

I come across some problems setting the page height which render in web browser. The “Report Properties”-> “Page height” setting never works. It only works when you export the report to pdf or image file. So the report height in browser is never change. I found a stupid way, but it works. Do open the report.rdl file with notepad and change “<InteractiveHeight>11in</InteractiveHeight>” accordingly. By default it always set to 11 inc. I cannot find anywhere in the visual studio editor to change this. So, here is the solution for me. For those who know where to set it in visual studio editor, please feel free to comment and let me know. Thank you in advance!

Do you ever get this error for normaly user when accessing your scorecard in sharepoint?

“There is a problem with this scorecard. Ensure that it and all dependant items have been published correctly and that you have adequate permissions to view them. If the problem still persists then please contact a system administrator.”

You do not have any problem when you are local administrator. You already set all the permission in your scorecard and datasource. But it still raising the error when you login as end user to view the scorecard. Since I am still new to BSM, it take me hours to solve to the problem. The trick is you must set the “global reader” permission to “NT AUTHORITY\Authenticated Users” in your BSM’s “Server Administration”->”Permission” setting. By default, it only set the local administrator’s rights.

I am having  difficulties to set the dynamic defaultmember for a dimension. Eg. I got a time dimension which use in BSM. I want it to always get today’s date as the dimension member so that i can get the MTD data from my cube. But some how it didnt works. I did try on vba!date() function as found in google as well but no help. The BSM time intelligence member only work and display data if i hard code the defaultmember in cube. Setting manually time dimension in BSM also no help. Does anybody facing this problem before? Will appreciate if can point out the tricks…. =)

Having difficulties to find help on reporting service’s functions like switch? You may not able to find any help on your local help. Go here to check on these:

http://msdn2.microsoft.com/en-us/library/ms157328.aspx

I got this error when trying to browse a cube. This happen once I installed MS SQL SP 2. From what i found, most likely the OWC component installation became corrupted. To solve this, just install OWC again. This works for me.

OWC installer.
http://www.microsoft.com/downloads/details.aspxFamilyID=7287252c-402e-4f72-97a5-e0fd290d4b76&DisplayLang=en

The following error text occur in the rigth pane:

Unexpected error occured: ‘Error in application.’

When trying to view the calculations tab (of any cube, including the samples that comes with SQL Server 2005) in Visual Studio (BI Development Studio) . This may cause by different versions of msmdlocal.dll and msmgdsrv.dll in %ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ and %ProgramFiles%\Common Files\System\Ole DB\

If they are not the same, then try to update the ones in the PrivateAssemblies with the ones from ole db (Please backup the dlls just case…)