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

WAD & Input-ready queries

Hi

I'm trying to create Web Application that enables users to change key figure values in the Analysis Item. What have I created so far:

- Real-time infocube (Planning is enabled).

- Aggregation level on the cube. I've also created some planning functions, such as functions for deleting all the data in the cube and saving the changes.

- Created a input-enabled query.

- Created an Web Application with analysis item and some buttons for planning functions.

All my planning functions work just fine. The guestion is, is it possible create such web application that would enable users to directly change single key figure values in the analysis item? Users would just have to click on the value that they want to change, type in the new value and then save.

I'd also like to enter new records to the cube with my application. Problem is that if I set the number of lines for new records above 0, I get error message "No new lines can be entered because axis is not input ready".

Any ideas?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2009 at 11:55 AM

    Hi,

    Lets discuss this in two parts :

    1) Creation of Planning Layout process and Creation of Open Query to achieve the desired layout...till this part its perfect and no issues.

    2) Now coming to web display part, a wad is created with Analysis Item to assign the query to the analysis item to display the query in the web. An analysis item is just a place holder to display the query in the web.Analysis item has no other means or purpose.

    Editing the keyfigure values happens as per the design of the query where Keyfigure property has been set to 'Can be Planned'. Analysis item in the wad has nothing to do with Keyfigure values.

    Can u help me in making clear when u say " i want to change values with my application"

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      It seems that there is something wrong with my query. I'm not even able to change the data with Analyzer, so web item settings are not the reason for my problem. I use following setting for my key figure:

      In Change Data (radiobutton group) I have selected "Input-Ready (Relevant for Locking)"

      In Disaggeration (radiobutton group) I have selected "No disaggregation"

      The Query is set to start in Change-mode and the infocube is ready for planning, not loading.

      Problem solved. I removed all free characteritics from the query and added them to rows/columns.

      Edited by: Ran-Dom on Mar 12, 2009 12:45 PM

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2009 at 12:01 PM

    WAD can enable planning applications to have input ready queries. Have you changed the real time behaviour of the cube by right clicking and changed that to no loadig, planning allowed status and check the input ready query in WAD.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2011 at 05:48 AM

    Hi,

    I have a requirement to change the characteristic values using Planning . May I know if this possible. And, also how should the master data for these be handled.As I am new to IP as such, can some one help me on this. And also, is it that only WAD supports to change the values and post them back to the cube or is it supported by our Excel front end too.

    Your help is awaited. Thanks in advance.

    Sudha

    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.