Hi Friends,
I have a one scenarion like. I have a class in Universe called Resource.
in that I have Resource name, resource Id, resource parent, resource structure.
I have created a prompt for resource name.
resource name inlist list of values, it is fetching the data for selected resource names.
here my question is, I want to display the resource Id information in the report other than resource name. but we need to give the prompt for resource name.
If you apply the prompt for resource name it has to fetch the data for reourse Id and it should be display resource id information in the report.
Could you please fix it.
Awaiting for your reply.
Regards,
Eswar
eswar519 (BOB member since 2009-05-26)
Hi,
Is there a hierarchy present or is it a straight table where Resource Id = Resource name ?
Why dont you try cascading prompts ?
-srujana
srujanaj 
(BOB member since 2010-02-10)
it is a straight table.
eswar519 (BOB member since 2009-05-26)
Hi Eswar,
Probably you can do like this.
In the Universe Designer. Select Resource ID object. Go to properties & Edit the object and pull Resource Name in the query panel and save it.
If you click on display and you can see both Resource ID & Resource Name as LOV’s.
Create a prompt on Resource ID and if you pull that prompt in the report then you will see both Resource ID & Resource Names. If you select a resource name then it will directly show the result of corrrespoing resource ID in the report.
Hope it helps you.
Thanks
Sharma
sharma03 (BOB member since 2006-03-25)