Here is an interesting article, “Last mile of Business Inttelligence”. You may face the same problem in the BI world these days.
http://www1.juiceanalytics.com/writing/2007/11/last-mile-business-intelligence/
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…. =)
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…)
