Re: Dependency tracking application
- From: fimiani@xxxxxxxxxxxx
- Date: Fri, 14 Nov 2008 07:04:23 -0800 (PST)
Ken,
Maybe I'm not getting what you're asking in total, but this seems
one:many, but maybe with distinct hierarchies; you may be able to do
this with a regular dimension (with empties) or parent-child
dimension.
This is an pretty original use of OLAP though, I like it. We did
something like this with a troubleshooting app that built paths which
we did by building parent-child dimensions that mimicked the decision
trees.
Yes, form what I understand, OLAP would handle this, but I'm not sure
what the Facts would be, maybe the files them selves with the files
sizes or other details being the measures.
With that maybe I can get you to think of it in a differnet way,
though.
One of the paths seems like a AppUsageDependency, that is what it is
required to actively Use the app.
The other path you enumerate is a AppPrepDependency, that is, what is
required to ready the application prior to using it (loading the
data , etc.)
If you have one of the hierarchies like so, likley called
AppUsageDependency, I might turn it upside down.
An app cannot exist sans a server (or client). So would the server be
the leaf or root?
Baring that, I think the server would be at the root, and the apps
would be the leaves.
You may even want to include the individual files (DLLs, other
components, etc) that the app requires, but not sure if you need it
that detail.
(I might even suggest server instance as well as an additional level
in there)
AppUsageDependency:
Server -> DBServer -> DBServerInstance -> App
I might also suggest having attributes at the server level in there
like for the Virtual or Physical (booleans), and IPAddress.
AppPrepDependency:
Server -> DBServer -> DBServerInstance -> ETLJob -> SourceFile
Usage:
When they browse the dimension (in the report no matter what UI you
end up using), they could start at the bottom and work their way north
until they get the root, or the other way around, start on top and
work their way down.
Or you could use in your MDX query the Descendants and Ancestors
function would show you the complete path from root to leaf given any
root or leaf, or for the each of leaves.
-exologic
.
- References:
- Dependency tracking application
- From: Ken
- Re: Dependency tracking application
- From: marco . russo . 2
- Re: Dependency tracking application
- From: Ken
- Dependency tracking application
- Prev by Date: Re: Dependency tracking application
- Next by Date: Re: Cube Build Error
- Previous by thread: Re: Dependency tracking application
- Next by thread: Re: Dependency tracking application
- Index(es):
Relevant Pages
|
