i have one repord called mgnt_issue
in that i need to replace few measures that belong to mgnt_fact table with mgnt_snapshot_fact table.
do i need to do it manually or is there any options or sql statement that can replace these objects vth snapshot_fact…b’cos report is huge one.
i ve to change many functions .please let me know if any one of people know solution for this.
thank you everyone.
sonysunny4u (BOB member since 2007-02-12)
What kind of report is it (full client or WebI?)
What is the universe like? Does it have both tables in it? If so, you might be able to do something with Table Mapping – but you’d have to be able to reopen the query panel (in the tool that created the report) with a userid that has been set up in Supervisor to have the tables “swapped”, if you will, via Table Mapping – to generate different SQL.
Or am I totally misreading your question due to too little information?
Is this really for WebI 1.x/2.x (which corresponds to BusinessObjects versions 4.x/5.x) – or is this an XI issue?
Anita Craig 
(BOB member since 2002-06-17)