Value Filters for cubes do not load

So I created a cube that sums the transfer lines off posted transfer receipts, so by creating a pivot table with 1st level rows being the receipt number and second level row being the item number, I can get the detail of how many items were shipped per transfer.

My problem is the pivot table shows items with 0 quantity shipped, so the table is unnecessarily long. If I put in a value filter to the item number level to only show items with greater than or equal to 1 shipped, the table seems to freeze up saying "RUNNING OLAP QUERY" but more than an hour later, it still hasn't refreshed.

I've filtered that date to just April, so with the blanks, the pivot table has 350,000 lines, without the blanks, just 7500 lines. Has anybody seen this issue before?


Please sign in to leave a comment.