Hi,
I am using BO 6.5.
I want to create report on BO backend tables.
(Backend tables means object_m_actor etc)
I want to show Username,Report name,Last refresh date and all details about report.
From which tables I will get these information and how can I join that tables to each other.
Awaiting your favorable reply.
assist (BOB member since 2006-04-17)
Goto
Insert → Special Fiels → Date/Time —>last referesh
or insert → Cell
then go to formula functions there you have document functions use Dataprovider() function
you have Documentauthor() function also
sadick (BOB member since 2007-09-11)
Hi,
I am not creating report by using universe. I am creating report by using Free Hand SQL. I want to fetch data directly from base tables of Business objects repository.
(The base tables are like OBJECT_M_ACTOR etc)
I want to show Report name, User name who accessed report, Last Refreshed date and all other report related objects in the report.
Which table should I select for this type of report and how can I join these tables to each other. Is any commen key available to join that tables.
Awaiting your favorable reply.
assist (BOB member since 2006-04-17)
Hi,
Have a look on BOBdownload’s tere are several universes on the repositroy (for example BCA/users and documents). This post also could help you.
Regards