0

Creating a Subset of Date in the DS

Jet Reports Historic Posts

February 26, 2016 12:49

None

Follow

Hi Guys

Hi Guys
I am trying to create a subset of data in the data stage that I can then pass into the DW, for example:

I want to create a filtered range of G/L Entries for selected income accounts that I can then pass into the Sales Transaction table. What is the best approach to create this data set?

Thanks

Malcolm

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 02, 2016 19:48

  Hi Malcolm,
  
  Probably the easiest way to accomplish this would be to write a view. Since you'd need to have the full G/L entries available for the Finance Transactions/Finance Cube you wouldn't want to restrict that at all. Creating a custom view in the staging database and writing the SQL to create the view, then using the fields from the view in the data warehouse "Sales Transaction" table is probably the best option.