asked on October 17, 2018
Working with 2.223, trying to replicate a drill-down by created arrays for the drilledRows property of the report.
I'm unable to find any documentation on what the three members of the array should be.
For example:
[ -1, "[User].[User Hierarchy].[All Stores].&[All Stores]", 1]
I'm clear on the second element, but not the first and last.
⋅ October 18, 2018
Hi Nate!
The drilledRows are not presented in the documentation because this part of the report is not recommended for manual editing and can be the source of runtime exceptions.
If it's really critical for you to work with drilledRows I recommend you to update to the latest version. The structure of the drilled items is more clear in version 2.6.
Migration guides can be found here: https://www.flexmonster.com/doc/migration-guide/. Please keep in mind that the new version has backward compatibility with the old ones. In most cases, migration takes less than one hour.
Regards,
Tanya
⋅ October 18, 2018
It's not critical that I work with drilledRows, that is where I arrived while trying to apply drills to a report for export. The client doesn't want the lowest level of data, so expandAllData doesn't work, and I'm working with an OLAP datasource so I can't use expandData.
Does version 2.223 provide any functionality to accomplish what I'm trying to do? Given the time-frame I have I'd prefer a solution in my current version, if possible.
⋅ October 18, 2018
The most simple way to find the right structure for drilledRows is to load your cube in the component, drill all necessary nodes, then save and see drilled items in the saved report. You can just copy these rows to your report.
Does it help?
⋅ October 18, 2018
I would like a dynamic solution, as this report is for a store hierarchy that may change in the future, and saving the xml will hard-code the region and store names, which would then break on the hierarchy change.
⋅ October 19, 2018
Hello, Nate,
Thanks for a quick update.
We would like to provide more details about drilledRows in version 2.2. In this version, the information about drill downs was generated based on our inner logic. This means it is possible to save such information in the report, open it later and all drill downs will be restored. However, setting such drill downs manually is not possible. Our development team took this fact into account when preparing the improvements to our next major versions. Our latest version has a much simpler structure for drill downs storing. You can check it by clicking 'Save' button and checking the content of the saved report from our demo: https://www.flexmonster.com/demos/js/connect-ssas/
Hope the information above would be useful.
Regards,
Tanya
⋅ October 19, 2018
That's what I needed, thanks.
