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

IP Report not input enabled

Hi Experts,

I have done the below activities to make an IP report for manual planning.

1)Creation of real time cube and made is available for planning by setting.

2)Created aggregation level on around 7Characteristics & 4Key figures.

3)Created a Bex query with all the 11 infoobjects as present in the aggregation level.

4)Made the query to open in change mode.

5)All 4 key figures are ready for input.

6)Created a WAD template with analysis grid and its source is BEx query.

7)Infocube in planning mode.

The planning sequence & planning functions are running as desired when executed.

However, even after all the above required setting when I run the WAD the key figures aren't coming as editable.

I every now and then get these 2 below errors in WAD.

'014 Transformer exception while transforming BEx Web templates'

'171 Unable to generate history entry'

However, when I ignore the messages I can still work properly on WAD and have completed the IP report

Also I checked for disaggregation option of key figures setting in Bex query under planning tab.

There I am getting below error.

'Not supported by server'

I learnt that this disaggregation property needs to be enabled only if manual planning is based on totals(e.g. result role) and not on individual rows of characteristics.

I have just 4 records in the cube which are unique so every line in the report is unique.

Even though all the criteria's are met I am still not able to get IP report with manual editing option.

Please provide your valuable inputs.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jan 24, 2012 at 06:31 PM

    Hi Neeraj,

    without disaggregation setting a cell in the query can only be input-ready if the values of all characteristics used in the aggregation level are uniquely determined. In other works, the cell must not be aggregated with respect to the aggregation level.

    In you case this means that the 7 characteristics have to be

    - drilled-down in rows or columns

    - or restricted to a single value in the fix or dynamic filter of the query

    - or restricted to a single value in a restricted key figure.

    Disaggregation is available since BW release 7.00, SP13 and Query Designer 7.0, FEP14. Maybe you are confusing the 'not implemented on server' message in the Query Designer for the disaggregation setting with another setting 'planning on hierarchy notes'. The latter setting has nothing to with the disaggregation setting.

    Regards,

    Gregor

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Gregor Dieckmann

      Hi Gregor,

      Thank you for your inputs. I re-created the aggregation layer and it worked.

      However, I am facing a new issue.

      My IP report requirement has Key figures to be shown in rows and just calendar month in columns.

      The IP report should have drop down options for customer, product & year.

      Now the issue is unless I pull the 3 filter characteristics in my rows or columns I am not able to make the IP report input enabled.

      If I pull them in columns and hide the final IP report runs into 100 of pages and IP report takes a long time to execute.

      If I pull them in rows and hide the structure doesnt support that and no data is seen.

      If I put them in filters then they arent available for dropdown in IP report.

      How to overcome this issue. Can I restrict the no of pages displayed on IP report?

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.