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

Add new line with compounded characteristics ANALYSIS FOR EXCEL


I have a intrgrated planning query. I am opening this qury using analsysis for excel.

We have charactrestics Account no and charts of account componded with Account no.

When ia giving account no value it is inot compounding with the charts of accountant.

it foreces me to enter the completed compounded key.

How it can be done that i give only account no.? is there anyproperties need to be changed.

helpful answer will be rewarded.



Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Oct 30, 2014 at 09:50 AM

    I am not sure if the IP query is the same as the BEx query, but please see this thread by SCN members that addresses what to do with a compound characteristic in a BEx query

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Naveen,

      I think I can remember that in earlier AO versions it was also necessary, to insert filter values via the clipboard button always with the compounded key.... Otherwise it did not work.

      In the meanwhile it is not required anymore and you can insert a filter value with or without the key.

      Just give it a try... and then upgrade to a newer Version.

      Best regards, Martin

  • author's profile photo Former Member
    Former Member
    Posted on Nov 05, 2014 at 01:25 PM

    Hi Naveen,

    I have the exactly same issue, and I am using AAO 1.4 SP7.

    Please let me know if you find a solution.

    For now, I am showing the users how to enter the values with the compounding and a "/".

    for example: Chart of Account COA1 and Account 1000000 they need to type "COA1/100000".

    It works fine in BEX without the compounding, but I already started all my workbooks in AAO and published to BOBJ Launchpad and would not like to get back to BEX.

    Another limitation that I found was the number of new records to load, where in BEX I was able to load 10,000 new rows at once and in Analysis for Excel there is hard limit of 1000 rows.

    Thank you

    Rodrigo Silva

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2014 at 11:29 AM

    We are having the same problem. There is an idea in the idea place. But as far as I know this I not on the schedule. Especially if a general filter is set for the query it makes no sense to insert this value because it is not possible to add another value anyway.

    Enter values of compounding characteristic in planning as displayed : View Idea

    Please vote for it! 😊

    I also ran into the 1000 rows limit. 😉

    But I think that is ok. It's also a problem of the performance when talking about this quantities.

    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.