How to pull the elements of the Data Area of a slice?

For background, I'm trying to setup a drillback action that references a slice. In that action, I need to reference the elements that are set in the Data Area of the slice. It's easy enough to pull the elements for the Rows and Columns using the report object reference, "ReportObjects.HB_[SliceName]_Rows.Text", and "ReportObjects.HB_[SliceName]_Columns.Text", but is there a way like this to pull the elements for the Data Area?

Thanks,

Jacob

Find more posts tagged with

FAQs, How-To's, and Best Practices

Comments

Matthew Nye

To my knowledge, Im not aware of any way of accessing the Data Area elements. Be curious to hear someone from GPS or the EPM teams input on this.

Is this a Mingle Drillback? If so, keep in mind you cant do drillback on multiselected dimension elements. And due to that limitation theres really no need to have your Data Area elements available in the Rows or Columns collection. What I do is replicate the data area selection on the report canvas and then reference the cells in my drillback action.

hth,

Matt

JacobDavis

Thanks for the quick response Matt. Yes, it's a mingle drillback. Good reminder on the multiselect, I won't actually be using the row and column object references in the drillback action, I'll be using cell references since they're dynamic. However, the data area is static, so I was hoping there was a way to reference that list of elements and put that in the action.

Matthew Nye

Yeah, i havent found a way to access the Data Area.

if you wanted to keep it all in the slice element you could move your entire Data Area to the row or column collection and then only add the dimension IDs you want to display in the Slice HBs. You could then place the data area dimensions in non-viewable space for reference. Not sure thats saving you any more time than just replicating the data area manually in the report itself, but if theres some secondary benefits you see that COULD work (I think).

Copyright © 2025 Infor. All rights reserved.