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 thestatus andtrendfor theKPI, 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 gettingstuck for that. Would please any expert here give me any guidanceandadvices for that?

Thanks a lot in advance for that.

With best regards,

Yours sincerely,

[1092 byte] By [Helen999888] at [2007-12-25]
# 1

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

ThomasIvarsson at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
# 2

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,

Helen999888 at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...

SQL Server

Site Classified