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

WorkBook / BEx Analyzer - Excel Functionality - Custom Field Values.

Dear Experts,

I have an issue with the BEx Analyzer / Workbook. The following is the scenario. I have a keyfigure in my query and I have another field in the query which gets value from this keyfigure. for example:

KeyFigure NewField

10 10 (First Value would be the same)

20 10 (KeyFigure 2nd Value - 1st value)

30 10 (KeyFigure 3rd Value - 2nd Value)

30 0 (4th - 3rd)

50 20 (5th - 4rd)... Etc..

I achieved this by including a column on the query by using the excel functionality. (i.e.) insert a column and use a formula. The results are fine.

When i save it in a workbook and then when i open it. The field still shows values. However, when i refresh the workbook, the field is gone.

Any inputs will be much appreciated. Any workaround for getting the values for the field which is not in the cube will be rewarded.


SivaKumar K

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 01:39 AM


    Looks like some issue...U just log out & try again.BTW,Y u want to save it in workbook???Does it happens while use it thru Query???

    Chk again..It shld work.

    BI Learner.

    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.