Search results for query: *

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...

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...

Thanks for the great info! Felicity

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...

Thanks! I have asked about this.

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.

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...

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

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...

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...

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...

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