Operational Reporting from a Dimensional Model

Operational Reporting

Hello Everyone, We have a Data Warehouse built on Kimabll Architecture(Business Process and Grain Driven). Which is working fine and serving the purpose for Performance Management and Analytical Reporting. All data comes from a home grown source system

Can Data Warehouse be used as source for operational system

What are the pros and cons of using Data Warehouse (DWH) as source for an operational system? Background:- I work for a company who have now opted to use DWH to populate some of the small operational system's data base, The data in the DWH is

Real time datawarehouse replacing ooperational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW so

star data model and reporting with different dimension groupings

Dear community, I would like to ask you for helping me with a star data model / reporting problem. The simplified data model is: FACT_SALES (DATE_ID, PRODUCT_ID, CUSTOMER_ID, PLANT_ID, SALES_AMOUNT) DIM_PRODUCT (PRODUCT_ID, PRODUCT_NR,

Operational Reporting : DWH vs Legacy Application on Mainframe

I'm BI Project Manager in Organization and Process department in my company (ie from the business side and not IT side ). We have implemented a DWH with dimensional modeling. It contains absolutely all the data handled by the legacy applications on

Real time datawarehouse replacing operational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW and

anyone use Talend for a production dimensional model build

I'm looking at Talend as they seem to be on a roll with the recent inclusion of Data Quality and Master Data Management components into their suite. Wondering what experiences anyone has had building a standard dimensionally modelled Datamart or Data

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

Point in time reporting using ad hoc functions

Hi There Is there a BI tool that can handle the following two reporting scenarios? Please note scenarios to be preferably supported through ad hoc reports that user can build on the fly? Also, if you know how to achieve this functionality in a particular

Help - Reporting mechanism in TestNG

Hi, am using TestNG framework for running selenium scripts(java) of flex application. Recently i added a java code for image comparison to that selenium script. Now am able to run that script but the only issue is result of visual comparison is not

*Need help locating this file - Microsoft is reporting my site as unsafe? (updated, there is a virus)

Below is a message from several of the people that have gone to the site and tried to enter. I have several other sites, and this one was created for totally different topics unrelated to the original site. All of my other sites work just fine with no

Data Vault v's Dimensional Model

Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise