What is the disadvantage of Context Filters?

Home Forums Software Testing Discussions What is the disadvantage of Context Filters?

  • This topic has 1 reply, 2 voices, and was last updated 3 years ago by Nick.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #25839
    jhon
    Participant
    @richards12

    Hi, What is the disadvantage of Context Filters

    #25962
    Nick
    Participant
    @nickdevelux

    The context filter is not frequently changed by the user – if the filter is changed the database must recomputed and rewrite the temporary table, slowing performance.
    When you set a dimension to context, Tableau crates a temporary table that will require a reload each time the view is initiated. For Excel, Access and text data sources, the temporary table created is in an Access table format. For SQL Server, My SQL and Oracle data sources, you must have permission to create a temporary table on your server. For multidimensional data source, or cubes, temporary tables are not crated, and context filters only defined which filters are independent and dependent.

    Best Regards, Nick Cooper. Develux

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.