Need a special offer?Find out if your project fits.
+

Error when accessing record level data with Multiple Items selected in Filter

Answered
Ashleigh Hair asked on May 1, 2017

Hi All
 
I'm having problems accessing the record level data if I have a filter with multiple items selected.
There are no issues with multiple filters with only one item selected, but as soon as more than one is selected, when double clicking an aggregated value it comes up with "Error" - no further description. 
 
According to the Chrome debugger, the error is 

  1. Query (1, 566) The FIELD_NAME hierarchy is used more than once in the Crossjoin function.</faultstring>

Any suggestions for what may be causing this?
 

14 answers

Public
Roman Petrusha Roman Petrusha Flexmonster May 1, 2017

Hi Ashleigh,

This kind of error happens if you use items from the same hierarchy in rows and columns at the same time. Or items in columns and rows are somehow related to each other in your data structure. So I need more information about your cube and report's configuration to find the source of the problem.
Regards,
  Roman

Public
Michael Oborne May 2, 2017

here is a json used to show the issue, try opening any drillthough
 
{
"dataSource": {
"dataSourceType": "microsoft analysis services",
"proxyUrl": "http://olap.flexmonster.com/olap/msmdpump.dll",
"catalog": "Adventure Works DW Standard Edition",
"cube": "Adventure Works",
"binary": false
},
"slice": {
"pages": [
{
"uniqueName": "[Account].[Account Type]",
"filter": {
"members": [
"[Account].[Account Type].&[Assets]",
"[Account].[Account Type].&[Balances]"
],
"negation": true
}
}
],
"rows": [
{
"uniqueName": "[Geography].[Geography]"
}
],
"columns": [
{
"uniqueName": "[Product].[Category]"
},
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "[Measures].[Reseller Order Count]"
},
{
"uniqueName": "[Measures].[Discount Amount]"
}
]
}
}

Public
Roman Petrusha Roman Petrusha Flexmonster May 2, 2017

Hi Michael,

Thank you for this json. Now I can reproduce the issue.
We will add the fix to the minor release 2.316 (ETA May 22)

Regards,
  Roman

Public
Roman Petrusha Roman Petrusha Flexmonster May 9, 2017

Michael, Ashleigh,

We already fixed the issue. Please download the required fix from here:
https://s3.amazonaws.com/flexmonster/health.wa.gov.au/FLEXMONSTER-2017-HEALTH-WA-GOV-AU-MAY09.zip

Does it work for you?

Regards,
 Roman

Public
Ashleigh Hair May 11, 2017

Hi Roman,
 
We have downloaded and implemented the bug fix, and while it does allow us to now access the drilldown data window, it is not applying the filters - so if you double click on a value of 100 in the table, it shows more than 1000 records. 
I have emailed Olena an example - as i cannot post due to the sensitive nature of our data. 

Thanks for your help
Ash

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 11, 2017

Hello Michael Ashleigh,
Thank you for the feedback. Please note, at the top of the drill-through window, there are the details of the value: column name, row name, and the value itself. I.e., your screenshot shows drill-through of the cell with the value 100. This value is not connected with the number of records.
Please let us know if you have additional questions here. 
Best regards,
Dmytro.

Public
Ashleigh Hair May 12, 2017

Hi Dmytro -
This is a new issue - it has only been the case since the fix mentioned above.
Previously, if you applied a filter, then clicked on an aggregated data value of 2, it would only show you the 2 drill-down data records relevant to the filters applied. 
It is now showing all records, ignoring any filters applied.
At this stage, we will have to revert back to the previous version to regain this functionality. 
Please let me know if you need further explanation or examples. 
 
Thank you

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 12, 2017

Hello Michael Ashleigh,
Please have a look at this video example https://www.screencast.com/t/KcGuGwbhH3 from Excel pivot. As you can see the number of rows in drill-through is not equal to the number shown in pivot's cell. Also, please have a look at this video example https://www.screencast.com/t/dWd9ADZt3ED. After applying the filters the number of rows has changed but still, it is not equal to the value in pivot's cell.
Please let us know if you have any questions left.
Best regards,
Dmytro.

Public
Ashleigh Hair May 15, 2017

Hi Dmytro,
When I click on the links you reference above - I am taken only to a blank screen.
Are you able to provide the example in another format?

Thank you
Ash

Public
Ashleigh Hair May 15, 2017

Hi Again,
I've produced a dummy data set so that I can provide a specific examples, and have created the same pivot in both Excel and Flexmonster to show the difference in functionality. 
I tried to attach the examples here, but am having problems with the "Attach File" button below. 
I will email the example directly to Olena. 

Thanks

Ash

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 15, 2017

Hello Ash,
Thank you for providing us with the Excel example. We have reproduced the issue on our side and will be ready with the fix in the version 2.317 ETA Jun6.
Best regards,
Dmytro.

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 22, 2017

Hello Ashleigh,
I am glad to inform you that we have managed to prepare your fix earlier.
The minor release 2.316 is available for download now. 
You are welcome to update the component.   
Kind regards,
Dmytro.

Public
Ashleigh Hair June 14, 2017

Hi Dmytro,
 
Thank you for advising us of the latest release. Due to staffing issues we were only recently able to implement 2.317, however when selecting multiple items from a filter we now only experience the error "Details view is not available if report filter has multiple items. Report filter will be ignored."
This solution will not meet our needs, as the ability to choose multiple items on a filter is a requirement for our business. Is this a temporary work around until a more robust solution can be provided? If so, when will this be corrected?
 
Thanks for your help. 
Kind Regards,
Ash

Public
Tanya Gryshko Tanya Gryshko Flexmonster June 14, 2017

Hello Ash,
Thank you for the feedback. Currently, this requirement is not met due to OLAP cube structure restriction. The drill-through view is not available when report filter has multiple items. We will try digging deeper to see whether it is possible to implement this feature. As soon as we come to some conclusions we will contact you. Let us know if it works for you.
Regards,
Tanya

Please login or Register to Submit Answer