Uderc programming article aggregator sites
Index -> dimension hierarchy in data warehouse

dimension hierarchy in data warehouse

Advertisement

Unread      Implementing heirarichal structure in data warehouse

I want to create a data warehouse for credit card application. Each user can have a credit card and multiple supplementary credit cards. Each credit card has a main limit, which can be sub-divided into sub-limits to supplementary credit cards as requ

Implementing heirarichal structure in data warehouse

I want to create a data warehouse for credit card application. Each user can have a credit card and multiple supplementary credit cards. Each credit card has a main limit, which can be sub-divided into sub-limits to supplementary credit cards as requ

Foreign keys in SCD2 dimensions and fact tables in data warehouse

Hello. I have datawarehouse in snowflake schema. All dimensions are SCD2, the columns are like that: ID (PK) SID NAME ... START_DATE END_DATE IS_ACTUAL 1 1 XXX 01.01.2000 01.01.2002 0 2 1 YYX 02.01.2002 01.01.2004 1 3 2 SYX 02.01.2002 1 4 3 AYX 02.01

Data warehouse, time dimension

Dear folks, My boss asked me an interesting question, but I couldn't answer, because I'm not an Oracle expert, I'd rather describe myself as Cognos developoer. We have a ROLAP data warehouse, and there is a time dimension table, the primary key colum

View dimension hierarchy using the filter property of data form

Hi, I created a data form where I want to show the dimension hierarchy. But when I am filtering the form using attribute dimension then the hierarchy is not being shown in the form.Is their any way so that I can use the filter property also and make

Workspace Manager & Slowly Changin Dimension in Data Warehouse

Has anyone used Workspace Manager in a Slowly Changing Dimension to keep history in a Data Warehouse. What issues have you come across? What are advantages? What are disadvantages? Thanks UliHi Ben, thanks for getting back on this and sorry for not u

Dimension values without data in a fact table

I have an ODS system and a Data warehouse system I have a Sales fact table in the ODS system and I have these fields: SALES ID_CUSTOMER (PK), ID_MODEL (PK), ID_TIME (PK), SALES, QUANT_ART, COST Then in some records in the fields ID_Time or ID_Model o

How to convert number datatype to raw datatype for use in data warehouse?

I am picking up the work of another grad student who assembled the initial data for a data warehouse, mapped out a dimensional dw and then created then initial fact and dimension tables. I am using oracle enterprise 11gR2. The student was new to orac

Tablespaces and block size in Data Warehouse

We are preparing to implement Data Warehouse on Oracle 11g R2 and currently I am trying to set up some storage strategy - unfortunately I have very little experience with that. The question is what are general advices in such considerations according

Strategy in Data Warehouse Table Structure

I'm building a relational data warehouse, and there are two approaches that seem almost interchangeable to me, despite being quite different from each other.  The first approach is rather simple.  I have a "User" table with a bunch of foreign ke

Update data automatically in fact table in Data Warehouse

Hi, I'm working on the creation of a data warehouse that include different data source like SQL Server performance (more than one), Active Directory users, Server performance (more than one), Exchange server mailboxes. The problem is that performance

Why do we need SSIS and star schema of Data Warehouse?

If SSAS in MOLAP mode stores data, what is the application of SSIS and why do we need a Data Warehouse and the ETL process of SSIS? I have a SQL Server OLTP database. I am using SSIS to transfer my SQL Server data from OLTP database to a Data Warehou

Accessing Data Warehouse with HTML DB

I have a test data warehouse database 10g comprising of seven dimension tables and one fact table. When I access one table at a time, the query runs fine, but when I join two dimension tables or more to the fact table, the result set comes out wrong.

A Question Related to Dimension Hierarchy

Hi All, While going through some hierarchies, i found that some columns were associated with the levels in hierarchy but these columns were not part of level keys. I want to know that what is difference between the result when columns that are not le

Imported sealed Management Pack and its not showing up in Data Warehouse Job MPSyncJob

Hello, When i try to Import a sealed Management Pack (with defined new Dimensions for Data Warehouse) it works fine, and it shows up under Management Packs under the Administration Pane. But its not showing up in the Data Warehouse Job "MPSyncJob&quo

Export and Import in Data warehouse

Hi, I have built a data warehouse project with few dimensions and a cube on a server machine, say server1. Now i have another server machine on which i want to develop this project for bulk production. I want to import all the developments from serve

Compression and query performance in data warehouses

Hi, Using Oracle 11.2.0.3 have a large fact table with bitmap indexes to the asscoiated dimensions. Understand bitmap indexes are compressed by default so assume cannot further compress them. Is this correct? Wish to try compress the large fact table

OBIEE reverse engineering to go from SQL Server to a data warehouse

Hi, I'm new to data modeling for warehouses. We currently have an OBIEE environment set up where the data source was SQL Server transactional tables. The SQL Server data is to be moved to a non-Oracle data warehouse and I need to produce a logical da

Is the OBIEE used to create a data warehouses dynamically?

Management where I work wants to use the OBIEE Administrator to source a 3NF normalized database and create a "virtual data warehouse" in the Business Modeling Mapping layer of OBI Administrator as a Star Schema model is required by OBI Business

How do you link attributes in data warehouse

I am new to data warehouse and I am trying to get some direction on how tables, data is linked in the data warehouse archieture. For example in a rational database inorder to get data from several tables to print on a report I would have to join tabl