About former_member318041

former_member318041

Hi all, I am working with "SAP BusinessObjects Business Intelligence 4.2" and have the following problem. I would like to display a legend to a report with the individual fields from that report. Are the names of the fields that are displayed i...

former_member318041

Hi all,I am working with "SAP BusinessObjects Business Intelligence 4.2" and have the following problem. I need to replace certain strings within a variable by another string.E.g. if the strings is "abc", "odo" or "xyz", it needs to be replaced by th...

former_member318041

Hi everybody I am using BI 4.2 SP6 and I have a question concerning the naming conventions of reports. When scheduling a report, it is possible to have an influence on the name of the attachment. To my knowledge, the following variables can ...

former_member318041

The data in the spreadsheet contain two timestamps "INM Downtime Start" and "INM Downtime End". The task is to calculate and display the "Availability" per day. The challenge is that the calculated "INM Downtime (in minutes)" expands over more...

former_member318041

Hi all,I am working with "SAP BusinessObjects Business Intelligence 4.2" and have the following problem. I want to use the functions =QuerySummary() to generate a legend for the reports.The output of these functions is quite rudimentary.Does anyone h...

former_member318041

Hi Ayman, thanks for the quick answer, but this is not what I mean. I know this function NameOf([your object]), but I want to automatize the building of a legend. E.g., the function QuerySummary() states details about the query on the sql-level. It d...

former_member318041

Hi Mahboob,thank you for your input!When I was talking about a "separate area", I am talking about a "seperate page" (PDF) or a "seperate sheet" (EXCEL), as the reports are resulting in these formats.BR,Henning

former_member318041

Hi Ayman,I am was refering to objects when I was talking about "fields in the report".BR,Henning

former_member318041

Thank you!It is not as easy as I expected it to be - thanks again and have a great remaining day!Henning

former_member318041

Hi, thank you for the quick answer, but this is not exactly what I need ... I want to replace a string within another string and not the complete string!"ddddddabcddddd" --> "ddddddTESTddddd" This solution works when you need to replace complete stri...

User Statistics

User Activity

How to create a legend?

Replacing multiple strings by the same value

naming conventions of reports generated by scheduled queries

Splitting data by date

How to format the output of QuerySummary() ?

Re: How to create a legend?

Re: How to create a legend?

Re: How to create a legend?

Re: Replacing multiple strings by the same value

Re: Replacing multiple strings by the same value