Hi,

My primary questions are:
- How to implement this? Using virtual Cubes?
- How many Cubes are needed?
- Is it possible to implement without any complex programming (other than
using MDX)?

IMPORTANT TO NOTE: The CEO/other should be able to see the usage overview
either Global-level or User-level or Host-level or other levels, just by
clicking or drag/drop of appropriate parameters...

Details of data:

----Application-1 in Use for this hour-----

10AM-----|-----10.30AM------|-----11AM
<--------------->| (user1 in host1 used 1/2 hour)
The statistics for this hour (to be reported) are as follows:

A. Global usage overview:
1. Min = 1, Max = 2, Avg...
2. Time elapsed. ie. 1/2 + 1/2 + 1/2 = 1 1/2 hours

B. User-level overview:
B1. User1: Min=1, Max=2, ..
Time Elapsed = 1 hour
B2. User2: Min=1, Max=1, ..
Time Elapese = 1/2 hour

C. Host-level overview:
C1. Host1: Min=1, Max=1
Time Elapsed = 1/2 hour
C2. Host2: Min=1, Max=1, ..
Time Elapsed = 1/2 hour
C3. Host3: (Same as above 2....)

Note the differences of Max/Min/Time in A, B, and C.

A descriptive expl. would be highly appreciated!!

Thanks
philipus

--
Message posted via http://www.sqlmonster.com

let me know how do you differentiate the usages Global,user and Host in
your fact table.
If you explain the fact table granularity it would help me to
understand the analysis you want to make

Regards,
Prasanna

For example,

If 10 users use an application in different hosts (say concurrently), and if
you want to take statistics such as
- Global usage : Max./Min usage, and usage time (in hours) for that
application irrespective of user and host for any selected period (with
resolution/granularity of 1 hour or 1 day, 1 month, etc).
- User level usage : The same statistics, but for each user, but for the
same period and application
- Host.. : ... for each host...

Actually Im guidance for implementing (basic design) this, since Im not sure
how this can be achieved! So far I have been thinking that I should have
seperate cubes for each of the above, then use either MDX and/or the virtual
cube to appropriately merge-present the statistics.

As I said, the management guy would try to get the usage statistics of THAT
application initially. Then he would try to see the same type of statistics
for each User (drag-drop the User..), then, may be, for each Host (with or
without User)

Pl. let me know if you need further inputs.

Thank you
Philipus


pras wrote:

Hi Prasanna (or someone there),

Had a chance to see further info from me? Any idea of implementing this?

Philipus

Philipus wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1