Search results for query: *

In BCA you should be able to provide default values for prompts. As for the dates you should change the reports to make them dynamic, i.e. sysdate, sysdate + 1, etc

You see a list box, but you there should be a text box above it for you to type in a FREE value. You cannot change SQL manually in WebI 6.5.

You can create two universes independently and have same object names (say in different classes) and Reporter will pick up the objects. If you have two objects within a universe with the same name but different classes then BO will display an error message. It would seem that when you switch...

You have to use + as & is not allowed

You have to have a sub query that returns the Max Date per DIRY_EVNT and DIRY_NAR rather than the Max Date overall. 1 - You should be able to put this in the complex join, or 2 - How about a view or derived table that you can use as a bridging table, e.g. View would be something like...

Can you not change the Connections in Supervisor rather than in each Universe?

In Supervisor, on Configurations tab. Double click WebIntelligence Do you have correct permissions for Publications? It might be that

You can create a report level variable and then apply a filter on the variable. e.g. =If([Month (YYYYMM)]>200410;1;0) I've done a simple IF to look at the month, if greater 200410 then this variable is 1 else 0. I then filtered the report looking for 1's.

If ID column is the one you use to join the master table to the fact tables then there should not be a problem as it is conformant to both. It is probably worth converting the Col B NULL value to something like No Value, a meaningful number, etc so Drill Down will work, etc. When data is...

How about concatenating FROM and TO together, eg: FROM ||'----'|| TO 'London Heathrow' ||'----'|| 'Paris CDG' or 'Paris CDG' ||'----'|| 'London Heathrow' You can then look for: Destination Matches Pattern '%London Heathrow%' Any quicker?

Could it be one Page Server Process for Crystal XI and another for BusinessObjects Webi XI?

Don't use OLAP but I think you have to use the Oracle OLAP metadata bridge for BusinessObjects WebI to access Oracle OLAP cubes. Maybe Crystal XI has some other way of accessing Oracle OLAP?

A report instance is a pre-run report of a report definition. You do not run an instance again, so running it once or many times during Period 1 should give the same results, but then running it in Period 2 would give different results. Will the timestamps not indicate which period the report...

I would assume the Import Wizard does not do anything special to the universe, otherwise BusinessObjects would have suggested that using the Import Wizard was the ONLY way to migrate in order to have a supported environment.

Isn't a JAR file similar to a ZIP file? So have you tried installing the contents of the JAR file because it seems the message is suggesting that you are executing a JAR file? Hope that helps.

If you store in CE Repository then you can schedule reports to get the latest versions of Repository Objects when run. So if you make a change to an object and a report has this option set then on the next run it will pick up the latest definition. Using VSS you would have to make manual...

BO gives you a default of 'All Object Name values' as a default option on a drill filter. Most users are usually ok with that option.

skrandel's recommendation is a lot better. Thanks

Basically, the date key will then be joined to the four keys in the fact table, but in each case you will alias the Time Dimension (day level), and Time Dimension (month level). You would then have associated columns being returned from the aliased Time dimension tables, and in your SQL you...

You could remove the datebase SUM() in the object sumofactuals and use the Aggregation property of BO to do the summing. This would mean more rows returned by the database, but does allow you to get teh above to work.