Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• Experiences using Wherescape Red on SQL Server?

  I am struggling to find much content out online so I was wondering if anyone wanted to share their …

  aaa121

  3 replies

  11 years, 10 months ago

  By: emailgregn

• Aggregation With Condition

  Below is the scenario in which I have a question: Fact/Measures Table with the following columns: F…

  afaqshakoor

  1 replies

  11 years, 10 months ago

  By: Sean Lange

• Newbie Data Warehouse Question!

  Greets! Let me just clarify that I am just starting out with database administration and developmen…

  xsevensinzx

  5 replies

  11 years, 11 months ago

  By: xsevensinzx

• Repeating a date in both a dim and fact

  I have designed a warehouse which includes a type 2 order dimension and a accumulating snapshot tab…

  aaa121

  4 replies

  11 years, 11 months ago

  By: aaa121

• Dimensional Relationships on Tables

  Good Morning Guys, I am a newbie with regards to Data Warehousing And Implementation of a good Data…

  Stylez

  10 replies

  11 years, 11 months ago

  By: RonKyle

• Issue Logging System - OLAP Model

  HI All, We do have a reqirement to design a OLAP model for consolidating the issues identified on A…

  manickam

  3 replies

  11 years, 11 months ago

  By: robert.gerald.taylor

• Repeat attribute in two dimensions?

  Hi All, Each case has a status code (O - Open, C - closed etc). I plan to have a dedicated status d…

  aaa121

  2 replies

  11 years, 11 months ago

  By: RonKyle

• Dimension key in a fact table should be repetitive?

  We do have one to one relationship between a FACT table and Dimension table? Is it correct to have…

  manickam

  7 replies

  11 years, 11 months ago

  By: Koen Verbeeck

• Good analysing, reporting end-user tool ??

  Hi, I'm looking for a good analysing program for our end-users. It needs to be able to : build que…

  Serge Josse

  14 replies

  11 years, 12 months ago

  By: herladygeekedness

• DWH Practice

  Hi all, I'm looking for some advice for practicing DWH architecture/development with scenarios as …

  ntuschiev

  7 replies

  11 years, 12 months ago

  By: herladygeekedness

• Data warehouse assessment

  Hi, I'm searching articles, white papers, books, blogs, etc. about how perform a data warehouse ass…

  pmscorca

  1 replies

  11 years, 12 months ago

  By: herladygeekedness

• No dry book like Inmon/Kimball - Good beginner books for DW ?

  Please don't recommend books like Inmon and Kimball. They are dry and mostly abstract. I need a sug…

  etl.laptop

  1 replies

  12 years ago

  By: larskandersen

• Display all facts using latest set of dimension keys?

  I have a requirement where I need to provide two views of the same facts across several dimensions.…

  aaa121

  2 replies

  12 years ago

  By: aaa121

• good book for temporal db design?

  I was looking at.Temporal Data & the Relational Model (The Morgan Kaufmann Series in Data Mana…

  Maxer

  1 replies

  12 years ago

  By: Ken McKelvey

• Multiple Stars means multiple cubes?

  My company uses SQL Server 2008 R2 Enterprise Edition. I received data and a model from another age…

  DBA Cabuloso

  4 replies

  12 years, 1 month ago

  By: DBA Cabuloso