Offered traffic in business objects

[electron]

Hi Friends,


How we can calculate offered traffic in business objects?

We actually have average number of available TCH and I want to prepare a chart for TCH utilization. So in this case I would need to have offered traffic based on available TCH channel and Erlang B table with GOS 2% . Any idea?


Thanks

[saidou]

Hi,
You need to make assumption on your HR usage (for example 50%) and after that you calculate your capacity based on your TCH ( Nb_TCH * 1,5) with Erlang B and Gos 2%.

your utilisation TCH will the current average traffic divided by the value calculated above

BR

[electron]

Hi,
You need to make assumption on your HR usage (for example 50%) and after that you calculate your capacity based on your TCH ( Nb_TCH * 1,5) with Erlang B and Gos 2%.

your utilisation TCH will the current average traffic divided by the value calculated above

BR

friend,

i am exactly looking for erlang B table in business object(Or a trick to simulate it)


Thanks

[Darko]

friend,

i am exactly looking for erlang B table in business object(Or a trick to simulate it)


Thanks

You can use it through macro (Tools -> Macro -> VBA Editor).
It has VBA so it shouldn't be difficult if you like writing excel macros :p it's the same thing...

D.

[electron]

You can use it through macro (Tools -> Macro -> VBA Editor).
It has VBA so it shouldn't be difficult if you like writing excel macros :p it's the same thing...

D.

Thanks,
Do you have such sample or something similar to give me idea

[Darko]

Thanks,
Do you have such sample or something similar to give me idea

Long time ago I worked with BO macros, but only simple things related to autom. exporting.
My suggestion for you is to make BO report export(.txt) and calculate utilization using excel.
If you would like to learn more about BO macro programming here are some references (just for you to see how it is done :) ).

How to read a value from a cell (http://www.forumtopics.com/busobj/viewtopic.php?t=31914)
possible to access cell values and context values of cell ?? (http://www.forumtopics.com/busobj/viewtopic.php?t=20912)
How to loop the cells of a report via VBA script ? (http://www.forumtopics.com/busobj/viewtopic.php?t=17176)
VBA code to access the cell values in cross tab (http://www.forumtopics.com/busobj/viewtopic.php?t=17748)

[electron]

Long time ago I worked with BO macros, but only simple things related to autom. exporting.
My suggestion for you is to make BO report export(.txt) and calculate utilization using excel.
If you would like to learn more about BO macro programming here are some references (just for you to see how it is done :) ).

How to read a value from a cell (http://www.forumtopics.com/busobj/viewtopic.php?t=31914)
possible to access cell values and context values of cell ?? (http://www.forumtopics.com/busobj/viewtopic.php?t=20912)
How to loop the cells of a report via VBA script ? (http://www.forumtopics.com/busobj/viewtopic.php?t=17176)
VBA code to access the cell values in cross tab (http://www.forumtopics.com/busobj/viewtopic.php?t=17748)


By chance anybody has such report?

Thx