Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: flicg
  • Order by date
  1. flicg

    Project Technical Environments

    Thanks both. I would love to keep the environments separate, but my organisation doesn't have that concept at all, and I have never heard of anyone auditing project environments here. I want (and it is accepted here) for the business to be responsible for UAT and Training (except IT will...
  2. flicg

    Project Technical Environments

    Hi - I'm planning my project roles and responsibilities - specifically those responsibilities concerning data and technical environments. I was always taught that you need to keep your development, system test, UAT and training databases separate. That is great if you will be able to have a...
  3. flicg

    Miscellaneous questions

    Thanks for the great info! Felicity
  4. flicg

    Miscellaneous questions

    These are my outstanding questions, that is to say they are the statements that I think are probably wrong. Please can you help me to correct them? True or False? If false – please say why! 1. An ODS stores data in non-relational format 2. Fact tables and dimension tables exist at the...
  5. flicg

    Architecture options - European Service DW

    Thanks! I have asked about this.
  6. flicg

    Determining the required server horsepower

    A friend of mine with the same question asked their software provider, Peoplesoft, who put them in contact with the correct person at IBM (the hardware provider) who calculated the hardware size based on number of users, type of use, uptime (24 X 7 requires more hardware) etc.
  7. flicg

    Architecture options - European Service DW

    I need to provide a reporting solution based on a DW design for the service business in EMEA. The reports required have one thing in common: they will all use data from a Siebel Service/ClickSchedule deployment on a common European db. This is being rolled out country by country. The service...
  8. flicg

    Fact table boundaries

    Great! Feel like i'm on the right track, albeit feeling my way blindly! Thanks a lot for your help :)
  9. flicg

    Fact table boundaries

    Great,thanks, just what i needed! Opportunistic I know, but about measures, I understand that they are sums or counts of data, so for instance: total number of service requests, total travel time, total part usage, total working days. When combined in a MOLAP cube with a dimensional...
  10. flicg

    thread353-813028 cont'd... KPI's

    Senior management in the business should define the KPIs for their parts of the business. IT implement the way to measure those KPIs. The business senior mgmt know the business and should know what it is they want to measure in order to run that business better. Here is a KPI illustration...
  11. flicg

    Fact table boundaries

    It's my (recent) understanding that fact tables are built around (forgive my unexpert terminology) 'concepts'. I would say 'entities' or 'objects' if i didn't think those terms probably mean something else. So, one fact table would contain aggregaged data from different systems about say what i...
  12. flicg

    Fact table boundaries

    Can anyone tell me what defines the boundary of a fact table please? Thanks!

Part and Inventory Search

Back
Top