Posted: Wed Nov 23, 2011 2:07 pm Post subject: Exporting Data with Pipe Delimiter
I need to export data from several tables in a B/O Deski report (XI2) as a text file with pipe delimiter. In order to obtain the correct file format, I am creating a string, which is apparently working thus far. The issue is adding objects or variables that are measures. In using the FormatNumber function, a COMPUTATION error message is displayed. I've tried several options based on what was found in the forum or through searches to no avail. Any help will be appreciated.
Posted: Mon Nov 28, 2011 11:29 am Post subject: Re: Exporting Data with Pipe Delimiter
Thanks, Mark, but the problem is not with the date format....it's when I add an object or variable that is a measure -- for instance we have an object called Loan Count. If I add it to the end of the string, the COMPUTATION error appears.
Posted: Tue Nov 29, 2011 5:44 am Post subject: Re: Exporting Data with Pipe Delimiter
Add the variables/objects that will be in your string to the block and hide them via the functionality in format table -> pivot _________________ Available from October 2014 for contract/consultancy work throughout the UK
BusinessObjects - versions 3, 4, 5, 6, XI, XIr2, XI3.1, 4.1, SAP Integration
Data Warehousing, SQL Server 2000/2005/2008 (inc. SSIS, DTS, linked servers, stored procs), Oracle 7.3-11g, Netezza, Sybase, Informix, DB2, Progress, Ingres
Democracy: Where two idiots outvote a genius