Data View with data entry and pre-set values

Austin Yu

Hi guys,

I have come across this when trying to create a new screen for a revenue centre.

What I want to create is a similar function to Vlookup in Excel (see below).

Client is existing entity in Board. Class is a data entry cube. And i'd like to have revenue to look at another mapping table.

When user entered class as '1', a procedure or dataflow can look at the mapping table and prefill revenue value.

Client	Class	Revenue
A	1	50
B	3	75

Any idea how to achieve this?

Cheers,
Austin

------------------------------
Austin Yu
Commercial Analyst
Blue Cross Community & Residential Community Services
Australia
------------------------------

François DESREAUX

Hi Austin,

I have a solution for you with the version 10. I'm not sure this solution is the best one but it is a solution (if you have the version 12, you have somme opportunities with dataflow especially with tuples)

This solution consist in:

- create one cube "rev per client" with one entity "client" (A and B and C....)
- create a second cube "class allocation per client" with 2 entities, the once "class" (1 and 2 and 3....) and twice client (A and B and C....).
- create a calcul revenue cube (multiply cube rev per client * cube allocation per client)

- create a cube "Final revenue" with the 2 entities client and class updated by rhe procedure below

- create a procedure in order to update the final revenu

Regards
I hope this solution could help you. Perhaps there is another solution...I will happy to see it!
François

------------------------------
François DESREAUX
Consultant décisionnel (EPM + BI)
SEXTANT CONSULTING
France
------------------------------
-------------------------------------------