Possibility to edit data at consolidation level ?

[pmathur]

Hi all,

We have a bit strange requirement from our client :

Data is fed at the month level and consolidate at the quarter level.Now the requirement is like that the user after validating the data can also be able to edit/input the data at the consolidated node(for numeric type data).

I know in string case it will work but in numeric thing it is bit strange and a kind of impossible this. But still is there any way to accomplish this task.

Any help/suggestion would be really appreciated.


Thanks,
Priyank

[tomok]

Check out the Data Spread functionality. Clients can effectively enter data at a consolidated node and spread back to the months using a number of different spreading techniques.

[qml]

Data Spreads are a great and often underused functionality. If your users do not feel comfortable with using them, you might however need to consider building a multi-cube application, where you have cubes providing different levels of granularity (your C level in one dimension/cube is N level in another). Then by cleverly tying the cubes together with rules and/or TI's you can achieve a solution for the antediluvian problem of top-down vs bottom-up planning / data entry.

[pmathur]

Thanks tomok and qml ..... i will consider your suggestions

Regards
Priyank