We have an application which is outputting csv files where the dates are shown as "dd/mm/yy" with no leading zeros. So the 1st March 2001 would appear as "1/3/01". It also may output long database fields of >256 chars and containing hard returns and other special characters...
My friend has called someone out to look at his PC and the latest theory is that it is a side effect of being infected by the Klez virus :-( Needless to say I won't being opening any emails from my mate for awhile.
A colleague of mine has a Dell Inspiron 4000 portable with W2K Pro SP1 loaded. He complained that the PC was running very slowly and when I had a look at it I found that Winlogon was taking 90+% of the CPU and the disk is thrashing constantly. I have been unable to discover what the problem is...
I have written a procedure which fixes a historical data problem I have in a database. The problem exists in columns of VARCHAR2 type in several different tables. My proceedure works for a hard-coded tablename.columnname but I would like for it to be able to accept a table name as a parameter...
You need to create an object to plot on the graph. If this is just for a particular report you can create a report level measure variable (not just a formula) and just set the formula as =0.6.
If you want to have something available for lots of reports you could create the object in the...
There are a couple more things that could be affecting you. When the client universe is saved it needs to be using a personal or shared connection and the save for all users flag on the File/Save dialogue box must be checked.
The reports must also have the file saved for all users flag checked...
I can't give you a "magic" number but I can pass on some information which came out of a session at the UK User Conference on tuning.
Firstly, optimising the array fetch size is the single most effective way of increasing performance.
Secondly, it is very dependant on you network...
Does anyone know the codes that will work in the page label setting on Webi documents.
By default it has one field with a last refresh date and this uses a code <refresh_date>. I have also seen examples where it references an image file for logos. But I cannot see a list of available codes...
It is hard to be specific without seeing the exact structure of the data. You can use @prompt to bring back a range based on a single year entry. Eg. if you defined a condition which defined a range using BETWEEN @Prompt -1 AND @Prompt. You will still need to distinguish between data from the...
This is really two issues I am facing trying to solve the same problem. I have a database in Oracle 8.0.6 which uses a different character set to our normal corporate standard (including the repository). The client NLS_LANG settings are all set to the corp std and I have v8.1.7 middleware...
This is the example from BusinessObjects that I recommended:
How do you fill in the values of a prompt automatically, depending on the user login name, using VBA?
You created a report that prompts a user to select the values from the List of Values box.
You would like to know how you could...
I would recommend that you register with BO to get access to the tech support website. Although there are reference documents that accompany the SDK, there is little in the way of worked examples to help you understand how to use it. As I have never come across any text books that go beyond...
I have found the best source of examples for VBA is the BO Knowledge base. Documentation and exapmles from BO do seem to be a bit sparse. Just put VBA in the search criteria and have a browse. Have a look at Resolution #6988 which might be particularly helpful.
I am not sure whether this connected to your problem but here goes anyway. We had an issue with display of LOV's in Webi 2.6.2. If you have the Allow users to edit checkbox deselected in the object definition, the Values button used to call the LOV will not appear for Prompts when you try and...
Anyone know of a way to extract information about what objects, variables and formulae are used in a reports so I include them in my documentation. The structure view does not give me a complete enough picture.
Thanks
If you have the full version of Acrobat you can use the PDF Writer to effectively "print" to a pdf file. Once it is in a pdf file you can copy text out of it into Word all be it a page at a time. A bit clunky I know, but it does work.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.