Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Cergy
    Posts
    65

    Question Unanswered: Analysis Service: filter fact table ?

    I have a big table with several types of transsactions: PO (Puchase Orders, SO,( Sales orders), INV (Invoices) ....
    I want to create cubes with only one type of transactions (1 cube for PO,...)

    Where and how can I filter the rows I want to use in my cube ?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    create view, and for fact table in AS point at the view.

  3. #3
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    create view, and for fact table in AS point at the view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •