Relationship Lookup in Aggregated Pick State Fact Type

Follow

Peter Kristensen

• July 08, 2018 13:13

When I create a smart column or aggregation matrix with an Aggregated Pick State fact, I often want to show a pick list from a related element. So, I would like to be able to lookup related elements.

Currently, this is not possible. The workaround is to create a query to lookup the relationship, which is a stupid kind of query to create, because almost anywhere else in BA, it is possible to just lookup the relationship itself.

This feature request falls in the category of making BA more consistent to work and getting rid of annoying inconsistencies.

This is one case that I just encountered. The general feature request is to make relationship lookups available anywhere queries are available.

 

Regards,

Peter

0

• 

  Matthew Dodd

  • July 09, 2018 14:18

  This is an oversight - we aim to include relationships where ever you can select Queries for the reason you gave.  Who wants a query that is just "parameter -> find relationship"?  Hopefully we will get time to remove this discrepancy before the next release.

  Matt.

  1

  Comment actions Permalink
• 

  Peter Kristensen

  • July 19, 2018 06:09

  Also, when the source query elements' type is a relationship, it would be helpful to have access to source and target elements, so we avoid have the two queries "parameter -> find source" and "parameter -> find target".

  -Peter

  0

  Comment actions Permalink
• 

  Matthew Dodd

  • July 19, 2018 07:29

  This one is a little more contentious since we should really then provide ALL the options (e.g. parent/children etc) and this would be a large task.  The code for aggregations needs to be written especially per option.

  Matt.

  0

  Comment actions Permalink
• 

  Peter Kristensen

  • July 19, 2018 08:42

  And various options to support measure types of cause. :)

  I thought that might be opening a can of worms. More options for primary element would be a good start.

  -Peter

  0

  Comment actions Permalink

Please sign in to leave a comment.