I had a derived table created selecting 2 columns from a view. When I use the object from derived table and include existing objects from universe I get “incompatible objects error” when I try creating a report. Can some one please help me resolve the issue.
Basically the functionality I am looking at is there should be two LOV’s displayed when I run the report and if I select the first value report should use “measure a” else “measure b” to display the data in the report. please let me know how i can acheive the functionality?
You are likely getting this error because your universe has contexts in it. Once you put one context in a universe, every join must exist in a context otherwise you will get the error you have mentioned here.
Add the new join to the correct context and rerun your query. It should then work as expected.
Have you joined your derived table to your fact table on the key that you have in your derived table?
Without this, you don’t have a join and this is also another reason why you would get the error that you have.
So make sure you join your derived table to the table in the universe where it is required.
Add the join to the context if you have contexts in your universe.
Expose the object to the data manager.
Edit the object to make sure you have it configured the way you want.
Export the universe.
Open Webi.
Test new object with query.
Derived tables don’t show up in join lists, only joins do.
Is the derived table sat there unrelated to anything else?
If not, you will need to join it to something with the appropriate relationship.
You can then right click on the join you have just created and add the join to the correct context using the menu that will appear.
Don’t forget to save and export your universe before testing it
(BOB member since 2004-03-22)
Don’t forget to save and export your universe before testing it
(BOB member since 2005-01-06)