How to create a legend?

[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 in the report stored somewhere?

I would like to access these names, modify them and display them as a legend in a separate area.

Does someone have an idea how this can be done ?
Perhaps there is already something like this "out-of-the-box" that I do not know about?

Best regards,
Henning

[ayman_salem]

Do you mean by "fields in the report" are objects (dimension, measure, ...) and variables. or do you mean tables, diagrams, individual cells, ... etc.?

[former_member318041]

Hi Ayman,

I am was refering to objects when I was talking about "fields in the report".

BR,

Henning

[ayman_salem]

you can use =NameOf([your object])

ex: ="The " + NameOf([your object]) + " is for my Test"

[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 does also give you the objects that you use in the query itself.

The objects that you use in the query are not necessarily part of the report.
I am looking for something like QuerySummary(), where all objects are stated, that are part of the report!

In the next step, I will use this as a basis for the legend I want to create. My aim is to automate the creation of a legend as far as possible!

BR,
Henning

[ayman_salem]

Automatic is not possible.

However, you can use "References" to meet your requirement.

Example:

...

[ayman_salem]

The other solution (if you are familiar with RESTful) is to get the objects used in the document/report. You can then add a report (tab) with these objects (using RESTful) w/o a layout to the existing document/report.

[mhmohammed]

Hi Henning,

By "separate area," do you mean to show the legend as a different stand alone block and not in the Chart itself?

If yes, then we've few questions:

1. Are the LOVs (list of values / number of values) coming from that field going to be constant? Ex: If the field is Order Status, we know that the list is going to be constant (possible values may be Open, Backorder, Shipped, Complete)
2. Are you going to get the values from a different query?

One easy way to create a separate table for legend is:

1. Bring an empty Vertical / Horizontal table
2. Add columns to the right (if you're using a Vertical table) or add rows below (if you're using a Horizontal table)
3. Manually type in values in the different column cells or row cells (not in the header cells, table header should be hidden)
4. Change the background color of each cell (column / row) to make it match with the series color for that value in the Chart.

Thanks,
Mahboob Mohammed

[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