Search - Prologika Forums

Importing SSAS KPIs in PerformancePoint

Forging ahead through the unchartered land of PerformancePoint 2010, I ran into a snag today. Attempting to import Analysis Services KPIs resulting in the following error: An unexpected error occurred. Error 47205. Exception details: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by Teo Lachev on Tue, Sep 7 2010

Re: OLAPQueryLog - Unable to run Aggregation usage wizard

About the project configuration, BIDS needs to know which server to connect to. For this to happen, BIDS used the project settings and you can set up project configurations that specify different deployment settings.

Posted to Applied Microsoft Analysis Services 2005 (Forum) by Teo Lachev on Fri, Sep 3 2010

PerformancePoint 2010

PerformancePoint? Is it still around? It is (in SharePoint 2010), and it should peak your interest if you are serious about dashboarding. The planning component is of course gone and I have to admit I never had too much faith in it. When comes to dashboards, Microsoft gives you two implementation options: Reporting services reports in SharePoint web

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by Teo Lachev on Thu, Sep 2 2010

Re: OLAPQueryLog - Unable to run Aggregation usage wizard

Hi Ramesh, Thank you for taking the class. Not sure why you are nervous connecting to the production server as long as you don't deploy directly to it. I'd create a new Production project configuration and configure the project settings to point to it. That should be all that's needed for the UBO Wizard to find the query log. Alternatively

Posted to Applied Microsoft Analysis Services 2005 (Forum) by Teo Lachev on Thu, Sep 2 2010

Re: Analysis Services 2005 Filter web part - default member can be a mdx expression or not

It's been a while since I used an Analysis Services filter web part but I thing you may need to add UserName Tail( Filter ([Date Local].[Date Key].[Date Key].Members , ( ( [Advisor Organisation].[Advisor organisation].[Contact Center].&[Denmark]&[Kundelinjen], [Measures].[Calls Offered] , [Date Local].[DK Holiday].&[False] , [Date Local

Posted to Applied Microsoft SQL Server 2008 Reporting Services (Forum) by Teo Lachev on Thu, Sep 2 2010

Re: Reporting Services Toolbox items settings

Yes, you can consume report parts in RB 3.0 as the target audience would be business users. I thought about mentioning CRI but as you said, it would be an overkill.

Posted to Applied Microsoft SQL Server 2008 Reporting Services (Forum) by Teo Lachev on Wed, Sep 1 2010

Re: Reporting Services Toolbox items settings

Hi Michael, This is not possible. Instead, consider deploying common RDL elements as R2 report parts to promote consistency.

Posted to Applied Microsoft SQL Server 2008 Reporting Services (Forum) by Teo Lachev on Tue, Aug 31 2010

Re: Report Server Custom Security Extesion and Analysis Server

I'll need a closer look at this but the following should work for both shared and embedded data sources: 1. In the data source, specify credentials of a Windows user that has admin rights to the SSAS database. 2. Check the stored credentials and impersonate checkboxes. If this doesn't work, the next thing will be embedded data souce with UserName

Posted to Applied Microsoft SQL Server 2008 Reporting Services (Forum) by Teo Lachev on Mon, Aug 30 2010

Re: Prevent colomn merging in Excel

Make sure to align columns and with images as much as you can. If there is a misalignment, SSRS will introduce filler columns.

Posted to Applied Microsoft SQL Server 2008 Reporting Services (Forum) by Teo Lachev on Sun, Aug 29 2010

Re: Report Server Custom Security Extesion and Analysis Server

Well, as the error message indicates, you can't use Windows security on the data source. I think your best option is to use an expression-based connection string with an embeded data source for each report and set EffectiveUserName or use CustomData.

Posted to Applied Microsoft SQL Server 2008 Reporting Services (Forum) by Teo Lachev on Fri, Aug 27 2010