reporting requirement

[Former Member]

hi sapiens,

i have generated a report using the infoobject gl. so gl related data

is generated from cube into report.

glcode gldescription is generated in the report. the description is coming

from r3. now i want to change the description at query level.

Ex. glcode gldescription

200054 salaries

200055 fund

now i want the report like 2000054 salaries - division section

2000055 fund - accounts department

the description of glcode is coming from r3. now i want to manually put

all the glcodes and their descriptions at one sheet and refresh the query

that is executed with the new description from new sheet.

How will i do it.

Thanks in advance

Regards

Santosh

[Former Member]

Hi Santosh,

You can change The decription of your characterstic ( GL Account) in ROWS PROPERTIES. follow the steps.

1) Select the Char you want to change, Right click on it and go to properties

2) In properties you can find DESCRIPTION field, there you can change the description to what ever you want.

Note: You can change Decription at any time but not Technical Name.

Assign Points if it is you usefull

Regards

Sujan

[Former Member]

i dont have access for changing description.

Regards

[Former Member]

Hi Santosh,

If you dont have access to Query designer in order to change then at atleast you need to change the decription at Infoobject level. I mean changing the Infoobject description in its related TEXT table. after changing the text select the particular info object and right click on it and choose ACTIVATE MASTER DATA. By doint this you can have effect at Report level.

Note: After changing the description of Infoobject at BW level you need to close the QUERY DESIGNER and Agian you need to open it, by doing this all the updated Descriptions will come into the report.

If you dont have access even for this also, then its serious problem you must ask your TL to get access for you.

Regards

Sujan

[Former Member]

i cant do the same too...

can i do something in a workbook where one query has the old description

and the second query an excel sheet which replaces the query gl description

with new description.

Regards

[Former Member]

Hi

Best way write a VBA code in the excel sheet for replacement of G/L account description manually

This will replace all the GL description in the first sheet in to the second set of values you require to display

Assign points if useful

Thanks

N Ganesh

[Former Member]

do you have the extra desc you want to display in some form on BI. orlesemake it an attribute of GL and load it to the master data table where you can use the same at the query level.

[Former Member]

cant load into master data, coz its an access issue.

Regards

[Former Member]

forgot to write the same.

Issue is something like maintaining alternative gl description

Regards

[Former Member]

HI Santosh,

Voodi's suggestion is the best way to achieve your requirement. Apart from that You can create a table with GLcode and new description fields..Then create a virtual characteristic, while executing your query you can populate this virtual characteristic value with the new description from the table based on glcode using simple select statement in CMOD.

Hope it helps.

Ramesh

[Former Member]

Hi Santosh,

Both suggestiosn are great. Although the virtual char suggestion could mean activating some user exits that you might have never used before and some ABAP coding as well.

Another suggestion could be

1. Create a master sheet with all GL accounts and their descriptions that you want to be displayed in your report.

2. Create a seperate sheet (topsheet) where you write VLOOKUP formulas referencing the basic query sheet and the master sheet, and populating the values into the topsheet.

But do this if you know your set of GL accounts is a restricted set. If this report is for all possible GL accounts, then you might have to spend a day or more populating GL accounts and their required description in the master sheet !!

Hope this helps.

Prakash

[Former Member]

prakash n ramesh

i m new to reporting and i dont know how to do CMOD and VLOOKUP.

can u send some link or procedure.

Regards