 | |
Tool selection: web-based exchange of multi-dimensional data
comp.databases.olap comp.databases.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Tool selection: web-based exchange of multi-dimensional data -
08-18-2003
, 06:39 AM
#2
| |||
| |||
|
|
In our company we have a need for secure, web-based reporting. More specifically, we want clients to report to us, either using web based data-entry, or web-based data exchange. The kind of data we want our clients to report has a striking resemblance to the kind of data usually obtained through OLAP tools, albeit that we only require a single measure dimension. A complication may be that although for some dimensions all members are known and can be enumerated, there are dimensions for which enumeration of all relevant numbers beforehand is not feasible, e.g. bank-accounts. In this case we would like to specify a data-format with a simple validation rule. Our current line of thought is that we want to be able to specify a reporting need in terms of a multicube, with the possibility of specifying (ranges of) cells for which no reporting need exists. This seems very much feasible, and would presumably ease our effort in concisely defining the data need. Any hints of tooling in this direction would very much be appreciated. Another part of the problem lies in the fact that we want to use these definitions as a starting point for the generation of web-based data entry forms. We are not aware of any tooling, but we do think that the generation of web-based result screens isn't very much different from the generation of web-based entry screens. Ideally the solution provides: * secure data entry: encrypted data, non-repudiation, using a industry standard PKI infrastructure * a means of specifying cross-cell checks, i.e. arbitrary relations between (ranges of) cells, not neccessarily within the same dimension * instant feedback in terms of error messages when simple rules are violated, including validation of reported members of non-enumerable dimensions. * Updating of calculated cells, be it aggregates or used-defined functions. * minimal deployment: installation through the web * the solution is preferably browser-based and OS unaware * the solution has a proven track-record Any hints for (partial) solutions are more than welcome. Disclaimer: This message is part of an as of yet informal investigation, and any statements expressed herein are not necessarily in line with company decisions. |
#3
| |||
| |||
|
|
In our company we have a need for secure, web-based reporting. More specifically, we want clients to report to us, either using web based data-entry, or web-based data exchange. The kind of data we want our clients to report has a striking resemblance to the kind of data usually obtained through OLAP tools, albeit that we only require a single measure dimension. A complication may be that although for some dimensions all members are known and can be enumerated, there are dimensions for which enumeration of all relevant numbers beforehand is not feasible, e.g. bank-accounts. In this case we would like to specify a data-format with a simple validation rule. Our current line of thought is that we want to be able to specify a reporting need in terms of a multicube, with the possibility of specifying (ranges of) cells for which no reporting need exists. This seems very much feasible, and would presumably ease our effort in concisely defining the data need. Any hints of tooling in this direction would very much be appreciated. Another part of the problem lies in the fact that we want to use these definitions as a starting point for the generation of web-based data entry forms. We are not aware of any tooling, but we do think that the generation of web-based result screens isn't very much different from the generation of web-based entry screens. Ideally the solution provides: * secure data entry: encrypted data, non-repudiation, using a industry standard PKI infrastructure * a means of specifying cross-cell checks, i.e. arbitrary relations between (ranges of) cells, not neccessarily within the same dimension * instant feedback in terms of error messages when simple rules are violated, including validation of reported members of non-enumerable dimensions. * Updating of calculated cells, be it aggregates or used-defined functions. * minimal deployment: installation through the web * the solution is preferably browser-based and OS unaware * the solution has a proven track-record Any hints for (partial) solutions are more than welcome. Disclaimer: This message is part of an as of yet informal investigation, and any statements expressed herein are not necessarily in line with company decisions. |
#4
| ||||
| ||||
|
|
In our company we have a need for secure, web-based reporting. More specifically, we want clients to report to us, either using web based data-entry, or web-based data exchange. |
The situation you describe reminds me more of a planning application where
the users can input some data. Is their data coming out of a data store or
do they key the data in?
Quote:
|
The kind of data we want our clients to report has a striking resemblance to the kind of data usually obtained through OLAP tools, albeit that we only require a single measure dimension. A complication may be that although for some dimensions all members are known and can be enumerated, there are dimensions for which enumeration of all relevant numbers beforehand is not feasible, e.g. bank-accounts. In this case we would like to specify a data-format with a simple validation rule. |
multidimensional (MOLAP) or relational (ROLAP) since they are mainly
structure driven, meaning that there first has to be an element and second
the data to that element. Are the people keying in an account and maybe a
balance? Then your requirements might be easier handled by an operational
application (a Web page using https?). They could also send you a formatted
list with account, key figure 1, 2, 3... etc. and you import it at a later
stage. This way you can be sure to have all the necessary information. This
could also be keyed in in the form mentioned above.
Quote:
|
Our current line of thought is that we want to be able to specify a reporting need in terms of a multicube, with the possibility of specifying (ranges of) cells for which no reporting need exists. This seems very much feasible, and would presumably ease our effort in concisely defining the data need. Any hints of tooling in this direction would very much be appreciated. Another part of the problem lies in the fact that we want to use these definitions as a starting point for the generation of web-based data entry forms. We are not aware of any tooling, but we do think that the generation of web-based result screens isn't very much different from the generation of web-based entry screens. |
functionality for both reporting and planning.
Quote:
|
Ideally the solution provides: * secure data entry: encrypted data, non-repudiation, using a industry standard PKI infrastructure * a means of specifying cross-cell checks, i.e. arbitrary relations between (ranges of) cells, not neccessarily within the same dimension * instant feedback in terms of error messages when simple rules are violated, including validation of reported members of non-enumerable dimensions. * Updating of calculated cells, be it aggregates or used-defined functions. * minimal deployment: installation through the web * the solution is preferably browser-based and OS unaware * the solution has a proven track-record Any hints for (partial) solutions are more than welcome. |
solution? In order to give you better advice I need more information
regarding to your exact requirements. How do the input sheets look like? Is
there a planning process? Which reporting requirements do you have? As
already mentioned you might be better off building a Web interface using
SSL/HTTPS for the stated planning requirement. If you have further
requirements in your planning process you might want to have a look at
Applix (Interactive Planning), Comshare (shortly bought by a Canadian
ERP-company GEAC), Hyperion (Planning). This could be overkill though.
Kind regards,
Joerg
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.