Search results for query: *

Hi all, I'm trying to display Greek names from the database in BO full Client - I changed the NLS_LANG to GREEK_GREECE.EL8MSWIN1253 for Oracle - I set the regional setting to Greek to install the Greek fonts. - I make my query - I use "Arial Greek" in the cell format RESULT: I...

Hi, you can send me an email to tatiflette@yahoo.co.uk Gkar

Hi, You have two solution to this problem: 1 - Contact BusinessObjects support and ask them the solution to unlock the supervisor or to reset it's password. The solution is very fast and simple, but I don't want to give it here in a public forum 2 - Re-installing the server (WebI, BCA,...)...

Hi, Or you can select the table, go to the menu Format>>Table and then check "avoid duplicate rows aggregation" option in the "general" tab. Hope it will help GKar

Hi, You cannot do that in BusinessObjects. In the filter, you cannot select values that don't exist in the document. If you want to select values using a logical choice and if you are able to transform you choice in to a formula, you can define a complex filter. For example: you go to...

Hi, The two SQL generated can come from: 1 - the query needs to use two contexts to run. BO generate 1 SQL for each context. 2 - The option "Multiple SQL statment for each measure" is selected in the universe parameters. To check that, go to File>>Parameters and SQL tab 3 - Some...

Hi BIProf, Try to insert this part of code in you document after the refrech: ActiveDocument.ExportSheetsAsHtml ("G:\spnt\index") the full code should look like: Private Sub Document_AfterRefresh() ActiveDocument.ExportSheetsAsHtml ("G:\spnt\index") End Sub Hope it will...

Hi BOUser, of course you cannot run a VB script on a Unix server, only a Windows NT/2000 will do it. WebI is a web server, they is no way a Webserver can run a VB on the client side as the client can be a Mac, Windows with Netscape or Unix box. And it's very unsecured to run a script on the...

Hi A, The table you are looking for is OBJ_M_ACTOR You can find more much information on the BusinessObjects CD. On the CD, go in the Freeware folder and launch the file repositry.htm. You will find a description for each tables created by the supervisor Hope it will help you, CKar

Hi, Which version of Business are you using? I know that there are some problems like yours solved in the latest versions of BusinessObjects (5.1, 5.1.1 or 5.1.2) Have a like on http://www.techsupport.businessobjects.com for le latest version GKar

Hi, Yes, the lastest SP is 2.6.2 for Webi/BCA and 5.1.2 for BusinessObjects Full Client. You can go on http://www.techsupport.businessobjects.com to download them or order a CD GKar

In reporter, you can define new variables from the menu Data >> Variables and then use the functions available in BO to do what you want like: Mth=Month(<Date>) QTY=Quarter(<Date>) or =&quot;Q&quot;+FormatNumber(Quarter(<Date>),&quot;0&quot;) YRS=Year(<Date>) or...

Hi pquintan, It looks like you use the function DateDiff(&quot;s&quot;,db1.open_time,db1.close_time )at the SQL level. This function doesn't exist in the BO reporter. You will maybe find a solution on a &quot;SQL&quot; forum. Search SQL on the forum list and choose the one in relation with...

Hi mortac8, If you have a look to the BusinessObjects support website, you will find a solution for you. The article number 726 explain what to do: How can you display only the lines belonging to the maximum date / week via the Query Panel ? *****CONFIGURATION****** Any 4.x version...

kashew, you will find all the BO documentation on your CD in PDF format. You can use the online help as well From the online help: - Syntax Left(character string, number of characters) - Description Takes out the specified number of characters from the left of the character string. -Example...

Only MDAC 2.5 and 2.5 SP1 have this bug. In addition, Windows 2000 SP2 solve the problem. GKar

Only MDAC 2.5 and 2.5 SP1 have this bug. In addition, Windows 2000 SP2 solve the problem. GKar