Analytics Software

Hi All ,
I am new to OBIEE and comming from Business Objects background.I have following questions on each OBIEE tools .Really appreciate your answers
Thanks
Shivaji

OBIEE Repository Qstns


• If we change a table in DM (database) how do we refresh? If any Table is changed how do we refresh that change in Repository ? In other words If an extra column is added to table how do we refesh in repository?
• What is Online /off line means? ( I read in Manual and still not clear ..I came from BO background and in BO it gives diff meaning – Online means connected to security Repository and Offline means no connection to Repository)
• Why it is not advised to join with foreign keys in Fact tables to primary keys in Logical tables in Business model and mapping layer?
• Why do we need dimensions when it is not visible in Presentation layer? ( I know it is works to define Hierarchies .Any Example ?)
• How do we put a condition on logical table in Business model Layer (self join ex : country = ‘US’ )
• How do we define Row Level Security in OBIEE?
• For Every repository we have to define groups /users? Is there anyway we can define users/Groups once(in cetralized way but not with LDAP) use them in every repository?
• ST_DIM.ST_CDE = substr (RWA_FACT.BLDG_ID, 1, 2) Can we add this kind of joins between tables in Business Model Layer? OBIEE is not allowing, is there any reason?
• Can we create Filter Objects in Repository? (Ex: my filter Name: Prior 10 Years; condition will be TimeTable.FY_YEAR > 1996)? If so where and how do I create them?
• If I have a summary table and a detail table and let’s say Summary will give QTR revenues and Detail table will give Monthly Revenue. Can we create only One object and say Revenue and is depends on the query can it decide to go to Summary table or Detailed Table to get the appropriate revenue? ( in BO we have Aggregate Navigation )



ANSWERS Qstns


1.) How do we add a column to the report
2.) How do we apply a Rank to a report, for Ex : year ,customer ,amount .. If we run a report for 5 years ,I need top 10 customers per year to total 50 rows should be there in a report.


Dashboards QSTNS

How do we Migrate Dashboards from One Env ( DEV) to Another ENV (QA or PROD)
How do we Pass a YEAR Parameter in a drill report (a report which shows QTRs)
How to put a button to download a dashboard to Excel
How do we create an alerts (scrolling Texts)
How do we setup to send an elerts to email or Cell Phs
How do we map a dashboard to map (US map and let users click CA )
How do we put sorts on a table (with arrows) on a dashboard sections