Skip to Content
author's profile photo Former Member
Former Member

Filters based on Transaction data

Hello Experts,

I have a requirement, where i have three template selections personal area, personal subarea and Organizational unit. Personal area and Personal subarea are connected. Selecting one personal area would give me related personal subareas. But the relation with personal subarea and organizational unit is Many to one.

For example

Case 1:

Personal Area: 9000 (Region)

Personal Subarea : 9009 (Location)

Organizational Unit: 50000222 (Department)

in the above case if client selects personal area 9000 and personal subarea 9009, i should get 50000222 ready for selection.

Case 2:

Personal Area: 5010 (Region2)

Personal Subarea :1001 (Location2)

Organizational Unit: 50000222 (Department - same as above).

in Case 2 also my personal area and personal sub area selections should get 50000222 ready for selection.

if i give properties of personal area and subarea in organizational unit dimension i will be able to maintain only one property value for one organization, which is not fulfilling the requirement.


At the moment my organizational unit dimension is as below

orgnit ID Pers_area Pers_sarea

50000222 9000 9009

at trasaction data level (HR - employee headcount), i am getting multiple relations of these three parameters. Is it possible to get selections based on transaction data into template.

My employee data has below relations

Emp id orgunit pers_area pers_sarea

001 50000222 9000 9009

002 50000222 5010 1001

If transaction data based filters are not possible is there any workarround possible in this case?

Regards

Praveen

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 19, 2016 at 09:03 AM

    Looks like you have many to many relation?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2016 at 09:13 AM

    Hi Praveen,

    Thats quite a big post to read and understand....:)(confusing too...)

    Can you not maintain Organisational Unit property in Personal subarea dimension??? In this way many to one will be maintained.. and in your template you can fetch the property in a cell based on the personal subarea selected and then override that Org unit in the report/template.....whether input form or report!

    Hope this helps....

    Regards,

    JP

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.