Employee Hierarchical - Rolling down reporting

Employee compensation - Star or Snowflake?

I'm designing a data mart for employee compensation. The measures will include things such as salary and various bonuses. Most of the data marts I've designed so far have fallen rather gracefully into a star schema. For this one, however, I have

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

Need help with modeling employee and degrees earned

Requirements: 1) Provide monthly employee counts that can be sliced by an employee's degree granting institution(s) and/or institutional research activity levels 2) Count new hires by their highest degree earned at time of hire and/or by terminal

Employee Hierarchy Dimension Table

Hello All, I am trying to model a Hierarchical Table, I need some help on what is the best way to model this scenario I want to Flatten the Hierarchy Horizontally in the Dimension Table, I want to keep it as a SCD Type 1 Overwrite information The

Employee With Multiple Jobs

Hello; I am developing an Employee Transaction Dimension such as that seen in Figure 8.2 of the "The Data Warehouse Toolkit". In my case, an employee may have multiple jobs. Some of the attributes found in the Employee Transaction Dimension

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

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

Reporting Froms

Dear, Reader Well.. Ive my forum, there is it 3 Reporting places . -Report Player -Report GM -Report Bugs The point with the reporting with player & gm is: The members will not be shown , or read topics . So if it was a form we could

WSC, U.S. shippers meet on EU 24-hour rule

The World Shipping Council on Thursday conducted an information session for U.S.-based shipper and forwarder trade associations regarding the European Union’s new customs cargo security filing requirements. The EU rules are to enter into force Jan. 1

Reporting as Ordered

(Tuesday 30th May 1809) Vickery was still not clear why General Wellesley had taken such an interest in one of his Riflemen - and a new Rifleman, at that. The Rifleman himself hadn't sounded as though he was too clear about it either, which didn't help

Business Requirements Document

Does anyone have a sample or template business requirements document for a DW/BI project? I was looking to see what sections others are including and how they are structuring the document as I am just starting a new project. Thanks!

Drill-across relationships (Invoices -> Payments etc.)

I have a question regarding the relationship between fact tables to enable drill-across between these. I have a number of fact tables in my design, Invoices and Payments, are two of them. Invoices contain invoice amounts per invoice row. InvoiceNumber