| Author |
 Topic  |
|
|
m.andrysz
United Kingdom
8 Posts |
 Posted - 03/14/2025 : 06:51:14
|
Hi,
We are trying to use the attribute properties to speed up our report generation. Unfortunately, we observed that the properties are processed for all members, as there is no NON_EMPTY_BEHAVIOUR defined for them. We prepared an example report that shows the difference: http://www.reportportal.us/ReportPortal/design/view.aspx?reportId=2839
The difference is in the MDX; when the member for the property is defined and it doesn't have the "NON_EMPTY_BEHAVIOUR":
With member [Measures].[Education] as 'IIf([Customers].CurrentMember.Level.Name="Name",[Customers].Properties("Education"), NULL)'
It should look like this:
With member [Measures].[Education] as 'IIf([Customers].CurrentMember.Level.Name="Name",[Customers].Properties("Education"), NULL)',NON_EMPTY_BEHAVIOR='[Measures].[Sales Count]'
Please check the difference in how the report generates the results. We think that if it would be implemented as a default and the NON_EMPTY_BEHAVIOR was picked up from the default measure set for the perspective or cube using the properties, it would significantly improve our reports. At the moment, every time, when we add that property to the report's MDX, it is removed automatically.
Please consider adding this change.
Thank you.
|
Edited by - m.andrysz on 03/14/2025 09:02:37 |
|
|
admin
1640 Posts |
Posted - 03/14/2025 : 19:21:40
|
| Would ,NON_EMPTY_BEHAVIOR=[Measures].DefaultMember work? |
 |
|
|
m.andrysz
United Kingdom
8 Posts |
Posted - 03/17/2025 : 02:18:13
|
Hi. Yes, that would be helpful.
Thank you
quote:
[i]Originally posted by admin[/i]
[br]Would ,NON_EMPTY_BEHAVIOR=[Measures].DefaultMember work?
|
|
|
|
fdranguet
France
82 Posts |
Posted - 03/25/2025 : 05:09:39
|
Hello,
just checking if you did think about that slight change, and if you think it will be possible to implement that in ReportPortal for us? It would make a big difference since we would be able to use properties (instead of attribute hierarchies) in many of our reports to speed them up drastically.
Thank you!
Regards,
François Dranguet
Scott Bader |
|
|
|
admin
1640 Posts |
Posted - 03/25/2025 : 21:44:20
|
Please try this patch:
1. Download an unzip: https://reportportal.com/download/rp_209_CalculatedField.zip
2. Backup old files and copy unzipped files to:
\olap\CalculatedField.js
\olap\CalculatedField.aspx
\olap\script\main.js
3. Clear browser cache (admin > settings > version) |
|
|
| |
Topic |
|
Report Portal
Properties missing NON_EMPTY_BEHAVIOUR
