ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 hierarchy and attribute issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lordgunny

8 Posts

Posted - 10/25/2020 :  10:11:20  Show Profile  Reply with Quote
Hi, I have this problem on report portal olap report: If I drag a hierarchy in filter and then choice a multi select attributes inside the hierarchy, for example for Date.Calendar (January 2004 - February 2004 - March 2004 - 1 April 2004 ) then drag a misure for example Internet Sales Amount the result is correct but if I drag an attribute that is a part of hierarchy but it is outside too for example Date.Calendar Year in row, for view only the year in the report, the data change and show the total of misure for whole year so the filter is not considered; this behavior not happen inside the SSAS console. I created a report in your portal for reproduce the issue: hierarchy_attribute_issue_without_attribute: enter in edit mode view the result then drag the Calendar Year (inside the Data.Calendar Yaer) in the row; the result change and now display the data for whole year and not only selected in the filter. Thanks a lot for your support.

Edited by - lordgunny on 10/25/2020 10:18:08

admin

1637 Posts

Posted - 10/26/2020 :  20:58:19  Show Profile  Reply with Quote
Please try "Use subselect MDX for filters" option
Go to Top of Page

lordgunny

8 Posts

Posted - 10/27/2020 :  00:51:11  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]Please try "Use subselect MDX for filters" option



Thanks a lot for your support but I don't have this option on our report portal server because the version is ReportPortal 4.0 Build 189 so I believe that is necessary to upgrade to the latest version or is there a workaround ?
Go to Top of Page

admin

1637 Posts

Posted - 10/27/2020 :  20:11:28  Show Profile  Reply with Quote
Build 189 should have this option. Are you looking in OLAP report design mode?

https://imgur.com/kt8UkyE
Go to Top of Page

lordgunny

8 Posts

Posted - 10/28/2020 :  00:49:22  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]Build 189 should have this option. Are you looking in OLAP report design mode?

https://imgur.com/kt8UkyE



I saw the panel option in design mode but I didn't have this future
Go to Top of Page

admin

1637 Posts

Posted - 02/07/2021 :  21:14:46  Show Profile  Reply with Quote
Were you able to upgrade and try this feature?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page