Skip to Content
author's profile photo Former Member
Former Member

reporting requirement

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2007 at 08:51 PM

    forgot to write the same.

    Issue is something like maintaining alternative gl description

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2007 at 08:59 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2007 at 02:21 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2007 at 02:24 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.