I have created an Excel user form that incorporates locked fields that populate with customer information from a SQL server by way of OLAP CUBEVALUE formulas. It works great, however I have run into a problem b/c I have other CUBEMEMBER information that I need to display per user selection which is itself another CUBEMEMBER (Customer ID).
Does anyone know if this is possible and how it might be done?
A fictitious, simplified example of the SQL database would look like the table below. What I would like to show in user form is the "Risk Rating" based on the related "Account #" selected by the user. In Excel speak, it would work like a VLOOKUP or INDEX(MATCH) function.
<colgroup><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Does anyone know if this is possible and how it might be done?
A fictitious, simplified example of the SQL database would look like the table below. What I would like to show in user form is the "Risk Rating" based on the related "Account #" selected by the user. In Excel speak, it would work like a VLOOKUP or INDEX(MATCH) function.
<colgroup><col><col></colgroup><tbody>
</tbody>
"ACCOUNT #" is CUBEMEMBER | "RISK RATING" is CUBEMEMBER |
AA1 | 3 |
AA2 | 6 |
AA3 | 5 |
AA4 | 5 |
AA5 | 2 |
..... |
<tbody>
</tbody>