Jump to content

ireport - field mapping for parent child hierarchy


awiddowson

Recommended Posts

We have an ireport (3.7) running an mdx query through a mondrian connection. Mdx query is 'select {[Measures].[Employee Count]} ON COLUMNS,
  {Descendants(Filter([Organisation Structure.Org Structure].[unit].Members, ([Organisation Structure.Org Structure].[unit].CurrentMember.Properties("MDX Unit Id") = "$P!{UNIT_PATH}")), 1.0)} ON ROWS from [Establishment] where [RecentDay]'

We want the report to show employee count on one axis and the descendent of the parent child hierarchy on the other - at present it is displaying not the descendent on the rows axis but the highest item in the hierarchy.

The field mapping in the report query is set to Rows[Organisation Structure.Org Structure][unit] - I assume I can change this to get the descendent in the hierarchy rather than parent but how???

I've checked the documentation and samples and there are lots of examples where a hierarchy has fixed levels, ie time, but I cannot find any with a parent child hierarchy.

 

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...