If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need direction on simple Contributor App

Started by cognos_guy, 03 Sep 2009 03:08:27 PM

Previous topic - Next topic

cognos_guy

First, my disclaimer.  I am new to Cognos Planning.  I am looking for input in designing a solution (Analyst cube) to replace a highly manual yet simple business process with a Contributor Application.

Issue:
Sales goals for our salespeople are submitted by each branch manager on a monthly basis.  I then key the information into an Excel doc and upload to Cognos.

Solution:
I want to create a simple Contributor App (Analyst cube) that would allow the branch managers to submit the montly goals themselves.

Rules:
Goals are reported at the montly level but determined at the daily level therefore the "monthly goal=numbers of fiscal days in the month * daily goal".

A branch's total monthly goal does not necessarily equal the sum of the branch's salespeople (could be +/-);  There is a dummy salesperson set up for each branch (house account) that balances the branch total and the sum of the branch's salespeople; "house account = branch total - sum of the branch's salespeople".

Salespeople can belong to multiple branches
monthly goal number = daily goal number * number of fiscal days in the month

Dimersions are as follows
Fiscal Year, Fiscal Month, Number of days per fiscal month
Branch
Salesperson
"Salesperson's monthly goal  = (daily goal (input by branch managers) * number of fiscal days in the fiscal month)"

Any input would be appreciated.  Thanks

Milt

Hi, looks like a very simple application which you would have no problem developing in Analyst and then pushing out to Contributor.

I'd actually start with the infrastructure though.

1.How many branch managers are there ? (this would add significantly to the licence costs)
2.What is the network performance like to the branches ?
3.Are you taking data feeds from any sources like SQL or Oralce ?[/li][/list]
4.In your design, you might want to add a dimension which would allow for history to be kept and displayed
5.Finally, consider publishing the submitted data to a database so you have a back-up off all goal numbers

>Milt

cognos_guy

Hi Milt,

Thanks for your response.  My apologies for the delay.   :)
We have 6 branch managers.  Network performance to the branches is good.  This analyst cube is not taking any more db data feeds.  Thanks for the idea of adding a "historical" dimension.