WAD & Input-ready queries

[Former Member]

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?

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

Thank you for your answer.

What I mean is that I want to create a web application that allows users to plan individual keyfigures. For example:

Theres only one dimension in my infocube, wich in this case is customerID. For each customer there is just one keyfigure called discount. I want create an application wich would allow users to change the discount percentage of one customer at a time. I would also like to offer users a possibility to enter new customer records (customerID & discount %). What should I do?

Please note that the text above is just an example. The cube I'm working on is more complex.

[Former Member]

Hi Ran,

First part i.e., able to change the discount values of each customer sounds very regular planning application functionality. Display the Customer ID in the rows and Discount KF in columns with change mode then the objective of changing the discount values of each customer can be achieved, i do not see any challenge in that.

However, writing the charactaristic values into planning application from WAD is a challenge which i dont believe there is a straight forward method to achieve.But theres a way, slightly complex. What we can do is create a BSP application where the User can enter the new customer id's which inturn these customer id's have to be written into a ZTable created in BI and create a DSO on top of these Ztable by creating a generic datasource and pushing the values into DSO on which u can report newly added records.

Weigh u r options !!

Regards.

[Former Member]

Hi Ellora,

Thank you for your answers so far. They have been very helpful.

Display the Customer ID in the rows and Discount KF in columns with change mode then the objective of changing the discount values of each customer can be achieved, i do not see any challenge in that.

So it is possible to use the analysis item as a interface for changing data in the cube? Or what do you mean by rows and columns? I assume that by "change mode" you mean setting the mode of data provider?

I think I should learn these basics before getting to writing characteristic values...

[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