Search results for query: *

I have been grappling with a problem joining two tables that need to be joined on multiple columns. One metric is joining correctly (the second pass), but the first one insists on remaining joined on one field only. In general, how does the SQL engine decide when to join on multiple columns...

I am writing a report that combines metrics from two fact tables, but both are on the same level: From SDW_Exam_Fact I am counting contact_lu_id's at the program level From SDW_Completer_Fact I am counting Fact_ID's at the program level (the fact table itself is the unique combination of...

I want to create a crosstab report showing what programs/courses students are likely to take next. Here is the crosstab I would like to create: Program_2 Name Program_1 Name Metric: Count of Programs Completed Program_A2 Program_B2...

I am working on a report that shows students names, the total number of classes they passed, and the date of the last class each passed. These are students who have not graduated, and the way I accomplished that is by including a report as filter, the sub-report being a report of graduates and...

Here is my situation: Running v.7.2.2 on Oracle 9i Warehouse Tables: Course_Dim has the name of the course Student_Dim has the student's names, date of birth Start_Date_Vw - a view of the Time dimension for date student started the course End_Date_Vw - a view of the time dimension for date...

To all, I am adding several new star schemas to an existing data warehouse (MSTR 7.2.2/Oracle 9i). My predecessor used DB views to handle shared dimensions. Since performance is not great, I thought about using new column aliases (in the attribute form). Is that a good practice? Will this...

What is optimal for 2 related unv's: 1 huge DB or 2 DB's with redundant data? We are running BO in 3-Tiers with Oracle 9. Universe 1: Large Unv. file (460 Kb, 900 objects) uses 68 GB database. Currently in use with adequate performance. Universe 2: Universe not yet designed, about one-third...

I have read all the FAQ's and threads on hyperlinks. I can't find the syntax to use for linking from a Full-Client report (published and viewed in InfoView) that links to an ASP page on the web server. We have WebI reports that can do that (using universe object for the hyperlink) and FC...