Who is online?  0 guests and 0 members
Home  »  search results

Search Results: datawarehouse

31 results found
  • Foreign Keys in the Datawarehouse
    I personally like having PK-FK in the Datawarehouse. Apart from maintaing data integrity, these relationships make building the cubes pretty easy :). I would like to what other people in the forum do with their datawarehouse. Is it a good idea to have Pri
    Author: az.asharma az.asharma     Date: 6/9/2011     Section: Forum
  • Foreign Keys in the Datawarehouse
    Thanks for your post. The links provide useful information! Before posting on BIDN, I read the article on stackoverflow. That discussion makes strong points for both sides of the argument. I am hoping that people on BIDN can share their own experiences wi
    Author: az.asharma az.asharma     Date: 6/13/2011     Section: Forum
  • Learning/Relearning BI Part ...Um three
    The hesitation is because I have no brain cells left. Three letters for you....M D X. Oye! Seriously tho, it's not as bad as I thought it was, and conceptually it is relatively straightforward. So we got in today and started in on Reporting Services using
    Author: mattcushing mattcushing     Date: 6/23/2011     Section: Blog
    tags : bi, SSAS, SSIS, noob
  • My first anniversary on BIDN
    I have been introduced to the Business Intelligence concepts thanks to my manager way back in 2007. I have started working from DTS days and I have built a datawarehouse all by myself of which I was proud of. Then later on with the introduction of sql ser
    Author: indupriya indupriya     Date: 2/23/2011     Section: Blog
  • Dimension "Process Update"
    I am working in a scenario where I want to update certain cell values in the dimension tables (in the DW) and then bring those changes to the cube dimensions using "Process Update". I know there is a writeback option but I want to update my datawarehouse
    Author: az.asharma az.asharma     Date: 7/6/2011     Section: Forum
  • Aging Report For Trouble Tickets
    When you need these kinds of calculations it is much eaiser when you have an ETL process to tranfers this data into a datawarehouse where you can create all of these calculations in the ETL process. If you can't do this then you can do calculations in vie
    Author: MikeDavis MikeDavis     Date: 5/3/2010     Section: Forum
  • Replace traditional DW/BI solution deliver to fully automated with MSBI stack.
    Take a look at the DataVault Modeling and Methodology of Dan Lindstedt ( http://danlinstedt.com/ ) It's a hybride method (with best of 3NF and dimensional modeling) and tackles the flexiblity and maintenance issues you see. There are several software prod
    Author: in2bi in2bi     Date: 3/4/2011     Section: Forum
  • Date getting displayed as some random number when it is null
    sqlkala, Traditionally, when you are loading a datawarehouse with data and there are no values found during a lookup operation a value assigned to the NULL record is returned. This is what is happening to you and the reason for you getting the 1900-01-01
    Author: briankmcdonald briankmcdonald     Date: 12/8/2011     Section: Forum
  • BI Components of Office 2007 -- Part 1
    BI Components of Office 2007 We have built a datawarehouse in our sql server 2005 database and built some cubes in Sql server analysis services using sqlser server integration services. Now I wanted to utilise the BI capabilities of office 2007 to provide
    Author: indupriya indupriya     Date: 5/18/2010     Section: Blog
    tags : Excel 2007, SSAS
  • London Free Event : Next Generation Data Warehouse
    Microsoft & HP jointly presenting half a day free seminar on "Next Generation Data Warehouse" in London on 7th June 2011. Register Today
    Author: meganathank meganathank     Date: 5/5/2011     Section: Blog
  • Adding dynamic date logic to a datawarehouse
    Often with reporting on a data warehouse you see a common theme that many companies want to report on things with the context of my current date. Take for instance a sales report where you want to see this month’s sales activity. There are several ways to
    Author: MikeMollenhour MikeMollenhour     Date: 4/21/2010     Section: Blog
  • Date Dimension Indexes why not?
    Probably the most no-brainer in a DataWarehouse scenario is to index the heck out of the Date dimension. The cost of an index involves a couple of things: 1. How many inserts are performed on the table? 2. Fragmentation that may occur. 3. How much gain ca
    Author: MikeMollenhour MikeMollenhour     Date: 3/8/2010     Section: Blog
  • The Income Statement (3) the sales events.
    Learn what sales events are, to better implement your datawarehouse.
    Author: Stray__Cat Stray__Cat     Date: 6/8/2010     Section: Article
  • Datamodelling begins
    So I've decided to take a step in the right direction and begin the data modelling phase of my project. For those who didn't read my last blog post, I'm trying to find ways to study and get ready to take the BI Cert exam in September. I thought working on
    Author: SQLKohai SQLKohai     Date: 7 days ago     Section: Blog
  • Lets get it started!
    It's 2013, and I have several goals. Study for and pass the SQL BI certification exam - Implementing a DW with SQL 2012 Build a simple datawarehouse solution to practice with while I study Convince the powers that be, that it's a better idea to build some
    Author: SQLKohai SQLKohai     Date: 11 days ago     Section: Blog
  • Business Intelligence to me ?
    As a Developer ,I deal mostly with Microsoft Visual studio, HTML,code behind and SQL server stored procedures etc. However, BIDN , helps me gather more and more knowledge beyond my Development world .. So here I want to share with you all what I learn so
    Author: priti1desai priti1desai     Date: 3/3/2011     Section: Blog
  • Business Intelligence Architect
    I'm not certain what you mean by role but I'd be curious as well. I like the title you have. I started at the company I'm at over 2 years ago as a "Report Analyst" however most of my time (85%) is spent designing and building our datawarehouse. My title:
    Author: EGAN EGAN     Date: 12/15/2009     Section: Forum
  • Cube Design
    Cube design Am I the only one having this issue or is it a very common issue. For the cube I designed, I've intersections where the value is zero. I'm able to produce outputs only where there is a value. But my users want to be able to compare with other
    Author: Sabera Sabera     Date: 1/26/2010     Section: Forum
  • Cube Design
    thanks for replying . Let me see if this helps you. DimGroup DimGroupID Groupname 1 A 2 B 3 C 4 D 5 E DimBudget DimBudgetID RangeName 1 X 2 Y 3 Z DimGeography DimStateID Statename 1 AL 2 CA 3 IL DimAssociation DimAssociationID Name 1 M 2 N 3 O 4 P 5 Q Dim
    Author: Sabera Sabera     Date: 1/26/2010     Section: Forum
    tags : datawarehouse
  • SSAS Cube Separation
    Hi All, I am very new to Microsoft BI. I have DataWarehouse with PO table, PO table example Supplier PONum Supp1 PO01 Supp2 PO02 Supp1 PO03 Supp2 PO04 I want to create a cube based on supplier. Is it possible? I want to separate the cubes, so that Supp1 s
    Author: Kshitij Kshitij     Date: 6/16/2011     Section: Forum
  • How to find Logistic Regression coefficient using SSAS (data mining)
    On querying a logistic regression datamining model, is it possible to find out the coefficient? Its urgent please let me know. Thanks Sona
    Author: SonaPal SonaPal     Date: 7/19/2011     Section: Forum
  • Creating and Processing Cubes based for Year wise and Combine them in Report
    Hi, I am planning to create a new Cube Structure. I Have me Datawarehouse having the data for 4 Year. and i use to receive the data on daily basis. I want to perform the Cube processing only for current year. since there wont any data change in the previo
    Author: anandkumaran anandkumaran     Date: 3/31/2011     Section: Forum
  • Designing DataWareHouse OLAP, Minings for Health Care
    Hi All Can I have Any Design Help on Datawarehouse Design for health care . I have OLTP Database Records for Pataients/ Admissions/Proceduers given along with the results. What Useful information i can construct to help the Hospital. How can i design Mini
    Author: vineet_bidn_dubey vineet_bidn_dubey     Date: 4/5/2011     Section: Forum
  • DW design question
    I'm in the very early stages of design for a DW where I have state standardized scores for a school. The typical hierarchy is: A school reports to a district which reports to an ISD. There are some exceptions where there is no district, but the the school
    Author: rgtft rgtft     Date: 8/2/2011     Section: Forum
  • Use of Schemas in Data Warehouse Design - Need advice.
    That is awesome that you were able to attend Brian and Devin's SSAS workshop. I am sure it was very informative. As for your question and Devin/Brian's response... I would definitely do the same thing. It is actually pretty common to do that because secur
    Author: briankmcdonald briankmcdonald     Date: 11/29/2010     Section: Forum