Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
John Mark Bojanski  
#1 Posted : Tuesday, November 28, 2017 3:01:05 PM(UTC)
John Mark Bojanski
Rank: Newbie

Groups: Administrators
Joined: 7/29/2015(UTC)
Posts: 1

Is it possible to layer criteria in Targit to improve performance of an analysis or crosstab? For example, we have more retail accounts than individual years in our cube, so we would rather limit the years first and then move on to filtering accounts. It would be like applying an order of operations to criteria. Does the criteria bar apply first, before the comparison kicks in?
#2 Posted : Monday, December 4, 2017 8:40:51 AM(UTC)
Rank: Administration

Groups: Administrators
Joined: 4/7/2011(UTC)
Posts: 514

Hi John,

You cannot set a specific order for dimensions on your criteria bar. However, you can activate criteria bar auto-filtering (right click criteria bar to activate). Then you can carefully design your criteria bar dimensions left to right and train people in applying criteria in that order.

Furthermore, with the latest 2017 versions of TARGIT, you have an option to apply "required criteria" to any of your data objects, e.g. a crosstab. In this way you can prevent a crosstab from showing huge amounts and slow performing data until the required criteria have been applied. "Required criteria" is available from the Criteria Smartpad.

BR / Ole
Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.