| Author |
 Topic  |
|
|
gribog
18 Posts |
 Posted - 05/04/2016 : 21:46:09
|
Hi, I have a problem with KPI reports. When I create a new KPI report and click "Save report", enter report's name and click "Add report" nothing happens. I tried it in different browsers and no difference. When I try it in IE9 I get a script error: Unable to get value of the property 'selectSingleNode': object is null or undefined. URL: ...reportportal/KPI/Save.aspx? type=8.
|
|
|
admin
1637 Posts |
|
|
gribog
18 Posts |
Posted - 05/05/2016 : 14:32:41
|
| It fixed the problem, thanks! |
 |
|
|
gribog
18 Posts |
Posted - 05/09/2016 : 16:15:06
|
Hi, I think I have the same issue with Analysis Services KPI reports. Do you have correct script for that as well?
|
|
|
|
admin
1637 Posts |
|
|
gribog
18 Posts |
Posted - 05/09/2016 : 21:31:32
|
| On the demo server once I connect to a cube (such as Adventure works) and select a measure group I can see some KPI reports, whereas on my server after choosing a measure group I don't see any data. |
|
|
|
admin
1637 Posts |
Posted - 05/09/2016 : 21:50:32
|
Can you please see if there is a JavaScript error? In IE, open Internet Options > Advanced Tab > uncheck "Disable script debugging (Internet Explorer)". In Chrome, Options > More Tools > Development Tools > Console.
You can also try to connect to Demo server's XMLA service: (http://www.reportportal.us/xmla/msmdpump.dll) under Admin > Connections. |
|
|
|
gribog
18 Posts |
Posted - 05/10/2016 : 15:26:09
|
There isn't any JavaScript error and xmla connection on the demo server is working fine.
What I'm trying to achieve is to have a report like this:
Dimension Measure(value) Goal(value)
Where in Measure would be a data bar in addition to its value and in Goal would be a goal value with PKI icon. Goal value is not in the database and should be entered manually in report.
I tried to do this with OLAP report by adding calculation field and adding databar/kpi based on absolute value, but it lets me to add only one value for all rows, where I need different values for different rows. |
|
|
|
admin
1637 Posts |
Posted - 05/10/2016 : 18:01:04
|
Have you considered write-enabling your cube? The goal can be one of its measures and you should be to enter the goal for each row. The demo server has Foodmart 2000 > Budget cube right enabled. You can try it create a report based on it and write some data into it.
The OLAP report lets you pick KPI designed on the (1) SSAS side or (2) create KPI using the Calculated Member KPI Wizard (as you described). The KPI Wizard creates the KPI using one measure (as the numerator) and sum, max or absolute value (as the denominator). You would have to modify the generated MDX and replace the denominator with the goal measure. |
|
|
|
admin
1637 Posts |
Posted - 05/11/2016 : 14:35:14
|
If you don’t like OLAP write-back you can try this approach:
1. Create your KPI goal table and create data entry form for it (Design > Data entry)
2. Use the table as a measure group in your cube
3. Go to Admin > DB admin > select the measure group, process and save it a link report. When a user will click on the report the measure group will be processed.
4. Create KPI on the server or as a calculated measure (as described above)
|
|
|
|
gribog
18 Posts |
Posted - 05/11/2016 : 19:21:24
|
The thing is I don't want to modify the existing cube, so I'm trying to get benefit from calculated fields.
I can add several calculated fields (one for each row) to my report but I can't filter them by dimension. I would use only one row and several calculated fields filtered by dimension, but if I try to add filter such as filter([Measures].[Dimension].&[Value]) while creating databar calculated field I get a syntax error.
|
|
|
|
admin
1637 Posts |
Posted - 05/11/2016 : 23:18:56
|
Try using the MDX CASE Statement like:
CASE [Dimension ].[Hierarchy].CurrentMember.Name
WHEN 'A' THEN 65
WHEN 'B' THEN 75
WHEN 'C' THEN 95
ELSE 100
END
|
|
|
|
gribog
18 Posts |
Posted - 05/12/2016 : 15:52:23
|
Doesn't work for me, it shows numbers but doesn't want to display databars.
with member [Measures].[Total monthly profit bar] as
'" CASE [Organisation].[Level 03].CurrentMember.Name
WHEN 'Main' THEN "+ cstr([Measures].[Total monthly profit]/1500*100)+"
ELSE "+ cstr([Measures].[Total monthly profit]/500*100)+"
END
); background-repeat:no-repeat; width: 100px; text-align:right''>
"+format([Measures].[Total monthly profit],"Standard")+"
"' |
|
|
|
admin
1637 Posts |
Posted - 05/12/2016 : 20:26:21
|
Try MDX like:
"<div style=#39;background-image:url(bg.aspx?color=99ccff&value="+ cstr(
CASE [Organisation].[Level 03].CurrentMember.Name
WHEN #39;Main#39; THEN [Measures].[Total monthly profit]/1500*100
ELSE [Measures].[Total monthly profit]/500*100
END
)+"); background-repeat:no-repeat; width: 100px; text-align:right#39;>"+format([Measures].[Unit Sales],"Standard")+"</div>"
|
|
|
|
gribog
18 Posts |
Posted - 05/12/2016 : 21:15:22
|
Says:
The following syntax error occurred during parsing: Invalid token, Line 3, Offset 6, #. |
|
|
|
admin
1637 Posts |
Posted - 05/12/2016 : 21:51:48
|
| Please make sure that #39; is replaced with single quotes. Also can you try to create a simple example of what you are trying to do on the demo server? http://reportportal.us |
|
|
|
gribog
18 Posts |
Posted - 05/22/2016 : 14:56:52
|
| Yep, it's working now! Thanks! |
|
|
| |
Topic |
|
Report Portal
KPI Report saving
