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.