From excel sheets templates to D-lists and D-cubes

[Arcondo]

Hello,

I'm quite new on the planning field. Is there any smart way or tricks to translate business requirements (excel sheet planning budget) to D-list and D-cubes ? what should I focus on first ?

Thanks in advance for your help.

[StuartS]

Hello

To approach planning by considering translating excel spreasheets is putting the cart before thr horse, so to speak.

If I may suggest, a good way of approaching this is to consider the business processes.  I have come across numerous examples where people have said put this excel sheet/model in Cognos Planning, without considering the business process behind what they are trying to do.  For example, do all people who do this budget use the same excel spreadsheets, or are there variations between departments.

In terms of modelling ideas/approach a good start point is to study the sample models provided by Cognos with Planning.  There are too many variables to consider to be able to list them here.

I hope this helps.

Stuart

Also see these posts

http://www.cognoise.com/community/index.php?topic=5126.0

http://www.cognoise.com/community/index.php?topic=4807.0

[Arcondo]

Thanks for your quick feedback.
Cheers ;)