Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 different sources for dashboard. When I click the button dashboard should consider 2nd data source else 1st data source.
Please help
Hello Narendra,
Please refer attached sample application.
Hope this will be helpful.
Regards!
Rahul
Does data source has Same Structure or different Names. Can you elaborate more please
You can use a technique called "versioning" to handle this. Load everything you need from both sources, and mark all rows with a flag or indicator that identifies the data source. Also add this indicator to all composite keys.
Add a listbox to your dashboard with "Always one selected" enabled. You can create buttons to make selections in this listbox if you want to.
Later on, you can define common dimension tables that should be loaded only once and whopse rows applie to both "versions".