Filters based on Transaction data

[Former Member]

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

[former_member186338 · Accepted solution]

Looks like you have many to many relation?

[former_member186338 · Accepted solution]

P.S. You can show only intersections having transaction data if you suppress empty records...

[Former Member]

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

[former_member186338]

First of all the topic author has to completely describe the relations between 3 dimensions.  The sample is not complete... what about other orgunits?

[Former Member]

Yes...he has to state complete relations between the three..... I suggested it based on his current descriptions....