Odd Problem with ProClarity KPI designer

Hi, all here,

Thank you very much for your kind attention. Think maybe it worth posting my question about ProClarity as believing many of you may have been experts of ProClarity for SQL Server 2005 Analysis Services. :)

The problem I encountered is: when I created KPI with KPI designer in ProClarity desktop professional (I have got the whole ProClarity Analytics 6.2 platform installed), the KPI I created wont work if I added the status and trend for the KPI, only if I set 'none' for showing 'Status' and 'Trend' for the KPI I created, it will work but of course no KPI status and KPI trend. It's so odd. I have tried ages for that, still getting stuck for that. Would please any expert here give me any guidance and advices for that?

Thanks a lot in advance for that.

With best regards,

Yours sincerely,

Hello Helen. The KPI designer have a lot of different templates. Which one are you using?

You have also the possibility to create a KPI directly in SSAS2005 BIDs, under the KPI tab. You can try how they are presented in Professional 6.2 by browsing the Adventure Works cube that is part of the installation of SQL Server 2005(samples and tutorials).

The third possibility is to create a table in Professional 6.2 and map the values in that table in ProClarity Dashboard Studio 6.2 to targets. You will not get a trend however if you do not use the BIDS KPI tab or ProClarity KPI designer.

Regards

Thomas Ivarsson

|||

Hi, Thomas, thanks a lot for your guidance.

The template I used is: 'KPI with Goal, Status, and Trend'-which you have to write down MDX code. I have just found the problem caused by the syntax problem. It works fine now. Thank you very much for your help.

With best regards,

Yours sincerely,