Can a LOOKUP Dimension be used in Multi-Dimension Maps

643dp

Can I reference a LOOKUP dimension in a multi-dimension map? I've tested and it failed, so I'm guessing not. Is it possible? Thanks.

JohnGoodwin

It works for me

Cheers

John

WPaffhausen

Hello 643dp,

No lookup dims cannot be used in multi-dim maps.  They are not even visible in the dropdown selection as available dimension(s) when building the maps.

Thank you,
Wayne

JohnGoodwin

It works for me

Cheers

John

SH_INT

Ditto. I've seen LOOKUP dimensions working fine in Multi Dimension maps

WPaffhausen

Let me clarify.

Depending on the source system, number of dimensions currently existing, and sequence.... they may not show up in the drop down.  It is quite an interesting set of scenarios Oracle development is looking into.

Most notably:

For data-sync, open interface or universal data adapter locations, they will not appear at all.

For flat-file locations, I've had limited success on having them show up in the drop down... but it depends on the total number of dimensions.  Examples I have now with applications using the full 20 do not show up correctly in the drop-downs.

-------------------------------

Back to the original post:  Can you provide some updated information on your issue provided all the information provided?  Details from an error log or screenshot of what the issue is?

user6692921

The LOOKUP dimension needs to be assigned a field/value on the Import Format before it appears in MultiDim maps.

JohnGoodwin

Sorry but it works with UDA, OI and Data Sync.

WPaffhausen

Good to know.  I guess you can still learn a thing or two from time to time.

kafka89

You have to assign a field to it in Import format, otherwise it won`t be present in multi-dim maps.