on 12-22-2016 5:14 PM
Hi Experts, please could I ask your advice in achieving the following format
I need to make an EPM input schedule which has ACCOUNT and FLOW in the rows and TIME in columns. In the ACCOUNT dimension, I have a property called FLOW to which I have required the property values which I would like to have as FLOW members coming out dynamically in rows. I am able to have a single flow presented on a report if the property value in the FLOW property in the ACCOUNT dimension is say 121 but I cannot seem to be able to extract out the flows if I have a property value of more than one flow e.g. 121,130,150,170,181 please see diagram below?
thanks Colin
For sure "121,130,150,170,181" will not work! You are talking about many to many relationship between ACCOUNT and FLOW.
There are no builtin support of many to many relationship in BPC. Please look on some not elegant workaround here:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.