Search results for query: *

Hi All, I'm starting developing a datamart using oracle warehouse builder and as part of the dimension processing i need to check the incoming values of a dimension against the current version of the dimension. To do this I want to create a 'not in' subquery to check say the client code...

HI philloyd What about running two queries, one for ytd, on for 'this month' (or 'last month', whatever) and you won't need to put any filters in the report (not for this problem anyway) nathanjones

Maybe you could, instead of outputting the universe in html, create a set of xml tags for the metadata and find a way to output in this format :) busobj will <surely> have xml support in v3/6...

Hi, The first thing that comes into my head here is to create a number of aliases of your table and arrange them into a snowflake like pattern with child joined to parent as you go up the hierarchy, another solution if you're running on oracle would be to create a view and try the connect by...

'select.. from.. sample [block] n' is used to select a sample of percentage n from the table. Using sample with the BLOCK reference uses a percentage of blocks, without the block reference it uses a sample of rows (which one you use depends on how characteristic a sample you want, i.e. a 5%...

Hi, What version of webi are you using, what applet are you using (java/activex), are you trying to refresh/create a full client/webi documents, and have you tried the business objects forum? at first sight it sounds as if the number of wiqt.exe (the webintelligence controller processes) has...