I have a datasource with 150 Million data, and customers wanted to search few Dimensions with Bulk data search. They have Accounts/Books/Entity numbers in a excel.
I have created Datamart and given access to them to the datasource. It is very painful to type each number for each dimension.
Is there any other way to do "BULK SEARCH" across multiple dimensions.
Hi @krishnapriya Arisetti
Ah, that makes more sense :) You cannot use published data sources to join or relate together but you can blend. Blending is when you have 2 data sources - the Oracle one and Excel and then blend on the sheet. Blending does have limitations, but if you want to find all the data in the Oracle-based data that matches the Excel data that might be your only option.
----------------------------------------------------------------------------------------------------------------
Please upvote my helpful replies & choose Select as Best Answer if it really is the best :)