DRILLTHROUGH with filter

posted on July 10th, 2018

Answered

Gabriel Ribeiro asked on July 10, 2018

Hello,

Hi, I'm testing the component with the accelerator and detected an error when requesting a DRILLTHROUGH with filter.

json report - FoodMart.xml - Sales

{"dataSource":{"dataSourceType":"mondrian","proxyUrl":"http://localhost:50006/","catalog":"FoodMart.xml","cube":"Sales","binary":true},"slice":{"reportFilters":[{"uniqueName":"[Promotions].[Promotions]","filter":{"members":["[Promotions].[Promotions].[Bag Stuffers]","[Promotions].[Promotions].[Best Savings]"],"negation":true}}],"rows":[{"uniqueName":"[Promotion Media].[Promotion Media]"}],"columns":[{"uniqueName":"[Measures]"}],"measures":[{"uniqueName":"[Measures].[Store Sales]"}]},"options":{"viewType":"charts","chart":{"type":"bar_h"}}}

flexmonster.log.txt

jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxyImpl main
INFORMAÇÕES: Flexmonster Data Speed Accelerator for Pentaho Mondrian 4.4
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy start
INFORMAÇÕES: Version 2.5.4
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy start
INFORMAÇÕES: 
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy readConfig
INFORMAÇÕES: Reading config...
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy readConfig
INFORMAÇÕES: Reading config - OK

jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy loadJdbcDriver
INFORMAÇÕES: Loading JDBC driver...
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy loadJdbcDriver
INFORMAÇÕES: Driver path: jar:file:./postgresql-42.2.2.jar!/
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy loadJdbcDriver
INFORMAÇÕES: Driver class name: org.postgresql.Driver
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy loadJdbcDriver
INFORMAÇÕES: Loading JDBC driver - OK
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy loadJdbcDriver
INFORMAÇÕES: 
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy testConnection
INFORMAÇÕES: Testing connection...
jul 10, 2018 10:24:28 AM com.flexmonster.proxy.FlexmonsterProxy testConnection
INFORMAÇÕES: jdbc:postgresql://localhost/foodmart?user=postgres
jul 10, 2018 10:24:29 AM com.flexmonster.proxy.FlexmonsterProxy testConnection
INFORMAÇÕES: Data Source connection [foodmart] - OK

jul 10, 2018 10:24:29 AM com.flexmonster.proxy.FlexmonsterProxy testConnection
INFORMAÇÕES: 
jul 10, 2018 10:24:29 AM com.flexmonster.proxy.FlexmonsterProxy startServer
INFORMAÇÕES: Starting server...
jul 10, 2018 10:24:29 AM com.flexmonster.proxy.FlexmonsterProxy startServer
INFORMAÇÕES: Starting server - OK
jul 10, 2018 10:24:29 AM com.flexmonster.proxy.FlexmonsterProxy startServer
INFORMAÇÕES: Server is running at http://localhost:50006/
jul 10, 2018 10:24:34 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute 0 - false
jul 10, 2018 10:24:34 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
GRAVE: ERROR_SESSION_EXPIRED
jul 10, 2018 10:24:34 AM com.flexmonster.proxy.FlexmonsterProxyServlet handshaking
INFORMAÇÕES: Handshaking... 2.5.0
jul 10, 2018 10:24:34 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverDimensions
INFORMAÇÕES: Loading dimensions...
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.DiscoverArgs@70d1a905
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 20316704 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 1
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverDimensions
INFORMAÇÕES: Dimensions: 13 loaded [1880 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverHierarchies
INFORMAÇÕES: Loading hierarchies...
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.DiscoverArgs@70d1a905
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 21672016 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 2
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverHierarchies
INFORMAÇÕES: Hierarchies: 14 loaded [14 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverLevels
INFORMAÇÕES: Loading levels...
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.DiscoverArgs@70d1a905
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 22643144 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 3
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverLevels
INFORMAÇÕES: Levels: 41 loaded [8 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMeasures
INFORMAÇÕES: Loading measures...
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.DiscoverArgs@70d1a905
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 23534824 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 4
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMeasures
INFORMAÇÕES: Measures: 8 loaded [3 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: Loading members...[Promotion Media].[Promotion Media] - 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: searchPhrase 
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Counting members ... [Promotion Media].[Promotion Media] - true
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Hierarachy: [Promotion Media].[Promotion Media]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Search phrase: 
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Member: 
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: with member [Measures].[CountAllMembers] as Count([Promotion Media].[Promotion Media].allmembers) select NON EMPTY {{[Measures].[CountAllMembers]}} ON columns FROM [Sales]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Count members of [Promotion Media].[Promotion Media]: 15 [25 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: SELECT {} on 0, DISTINCT({{[Promotion Media].[Promotion Media].allmembers}}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, LEVEL_UNIQUE_NAME on 1 FROM [Sales]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.DiscoverMembersArgs@907065e3
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 26560424 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 5
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: Members of [Promotion Media].[Promotion Media]: 15 loaded [34 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: Loading members...[Promotions].[Promotions] - 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: searchPhrase 
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Counting members ... [Promotions].[Promotions] - true
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Hierarachy: [Promotions].[Promotions]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Search phrase: 
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Member: 
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: with member [Measures].[CountAllMembers] as Count([Promotions].[Promotions].allmembers) select NON EMPTY {{[Measures].[CountAllMembers]}} ON columns FROM [Sales]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countMembers
INFORMAÇÕES: Count members of [Promotions].[Promotions]: 52 [7 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: SELECT {} on 0, DISTINCT({{[Promotions].[Promotions].allmembers}}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, LEVEL_UNIQUE_NAME on 1 FROM [Sales]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.DiscoverMembersArgs@c008f447
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 28544160 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 6
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet discoverMembers
INFORMAÇÕES: Members of [Promotions].[Promotions]: 52 loaded [16 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute 0 - false
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: chunk: 0, from: 0, size: 100
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: query: with set [measureSet] as '{[Measures].[Store Sales]}' set [columnSet] as '{[measureSet]}' set [set_0_set] as '{Union({[Promotion Media].[Promotion Media].[All Media]}, [Promotion Media].[Promotion Media].levels(1).AllMembers)}' set [rowHierarchiesSet] as '{Filter([set_0_set], not (isEmpty([Measures].[Store Sales])))}' set [rowSet] as '{[rowHierarchiesSet]}' member [Promotions].[Promotions].[All Promotions].[(Total)] as 'Aggregate({[Promotions].[Promotions].[Big Promo],[Promotions].[Promotions].[Big Time Discounts],[Promotions].[Promotions].[Big Time Savings],[Promotions].[Promotions].[Bye Bye Baby],[Promotions].[Promotions].[Cash Register Lottery],[Promotions].[Promotions].[Coupon Spectacular],[Promotions].[Promotions].[Dimes Off],[Promotions].[Promotions].[Dollar Cutters],[Promotions].[Promotions].[Dollar Days],[Promotions].[Promotions].[Double Down Sale],[Promotions].[Promotions].[Double Your Savings],[Promotions].[Promotions].[Fantastic Discounts],[Promotions].[Promotions].[Free For All],[Promotions].[Promotions].[Go For It],[Promotions].[Promotions].[Green Light Days],[Promotions].[Promotions].[Green Light Special],[Promotions].[Promotions].[High Roller Savings],[Promotions].[Promotions].[I Cant Believe It Sale],[Promotions].[Promotions].[Money Grabbers],[Promotions].[Promotions].[Money Savers],[Promotions].[Promotions].[Mystery Sale],[Promotions].[Promotions].[No Promotion],[Promotions].[Promotions].[One Day Sale],[Promotions].[Promotions].[Pick Your Savings],[Promotions].[Promotions].[Price Cutters],[Promotions].[Promotions].[Price Destroyers],[Promotions].[Promotions].[Price Savers],[Promotions].[Promotions].[Price Slashers],[Promotions].[Promotions].[Price Smashers],[Promotions].[Promotions].[Price Winners],[Promotions].[Promotions].[Sale Winners],[Promotions].[Promotions].[Sales Days],[Promotions].[Promotions].[Sales Galore],[Promotions].[Promotions].[Save-It Sale],[Promotions].[Promotions].[Saving Days],[Promotions].[Promotions].[Savings Galore],[Promotions].[Promotions].[Shelf Clearing Days],[Promotions].[Promotions].[Shelf Emptiers],[Promotions].[Promotions].[Super Duper Savers],[Promotions].[Promotions].[Super Savers],[Promotions].[Promotions].[Super Wallet Savers],[Promotions].[Promotions].[Three for One],[Promotions].[Promotions].[Tip Top Savings],[Promotions].[Promotions].[Two Day Sale],[Promotions].[Promotions].[Two for One],[Promotions].[Promotions].[Unbeatable Price Savers],[Promotions].[Promotions].[Wallet Savers],[Promotions].[Promotions].[Weekend Markdown],[Promotions].[Promotions].[You Save Days]})' Select NON EMPTY [columnSet] DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , NON EMPTY Subset([rowSet], 0, 100) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM [Sales] where ([Promotions].[Promotions].[All Promotions].[(Total)]) CELL PROPERTIES VALUE
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countDataSetRows
INFORMAÇÕES: Counting rows ...
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countDataSetRows
INFORMAÇÕES: with set [measureSet] as '{[Measures].[Store Sales]}' set [columnSet] as '{[measureSet]}' set [set_0_set] as '{Union({[Promotion Media].[Promotion Media].[All Media]}, [Promotion Media].[Promotion Media].levels(1).AllMembers)}' set [rowHierarchiesSet] as '{Filter([set_0_set], not (isEmpty([Measures].[Store Sales])))}' set [rowSet] as '{[rowHierarchiesSet]}' member [Promotions].[Promotions].[All Promotions].[(Total)] as 'Aggregate({[Promotions].[Promotions].[Big Promo],[Promotions].[Promotions].[Big Time Discounts],[Promotions].[Promotions].[Big Time Savings],[Promotions].[Promotions].[Bye Bye Baby],[Promotions].[Promotions].[Cash Register Lottery],[Promotions].[Promotions].[Coupon Spectacular],[Promotions].[Promotions].[Dimes Off],[Promotions].[Promotions].[Dollar Cutters],[Promotions].[Promotions].[Dollar Days],[Promotions].[Promotions].[Double Down Sale],[Promotions].[Promotions].[Double Your Savings],[Promotions].[Promotions].[Fantastic Discounts],[Promotions].[Promotions].[Free For All],[Promotions].[Promotions].[Go For It],[Promotions].[Promotions].[Green Light Days],[Promotions].[Promotions].[Green Light Special],[Promotions].[Promotions].[High Roller Savings],[Promotions].[Promotions].[I Cant Believe It Sale],[Promotions].[Promotions].[Money Grabbers],[Promotions].[Promotions].[Money Savers],[Promotions].[Promotions].[Mystery Sale],[Promotions].[Promotions].[No Promotion],[Promotions].[Promotions].[One Day Sale],[Promotions].[Promotions].[Pick Your Savings],[Promotions].[Promotions].[Price Cutters],[Promotions].[Promotions].[Price Destroyers],[Promotions].[Promotions].[Price Savers],[Promotions].[Promotions].[Price Slashers],[Promotions].[Promotions].[Price Smashers],[Promotions].[Promotions].[Price Winners],[Promotions].[Promotions].[Sale Winners],[Promotions].[Promotions].[Sales Days],[Promotions].[Promotions].[Sales Galore],[Promotions].[Promotions].[Save-It Sale],[Promotions].[Promotions].[Saving Days],[Promotions].[Promotions].[Savings Galore],[Promotions].[Promotions].[Shelf Clearing Days],[Promotions].[Promotions].[Shelf Emptiers],[Promotions].[Promotions].[Super Duper Savers],[Promotions].[Promotions].[Super Savers],[Promotions].[Promotions].[Super Wallet Savers],[Promotions].[Promotions].[Three for One],[Promotions].[Promotions].[Tip Top Savings],[Promotions].[Promotions].[Two Day Sale],[Promotions].[Promotions].[Two for One],[Promotions].[Promotions].[Unbeatable Price Savers],[Promotions].[Promotions].[Wallet Savers],[Promotions].[Promotions].[Weekend Markdown],[Promotions].[Promotions].[You Save Days]})' Select NON EMPTY [measureSet] ON COLUMNS, NON EMPTY [rowSet] ON ROWS FROM [Sales]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet _countDataSetRows
INFORMAÇÕES: Total rows: 15 [305 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute - duration: 465
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute - set chunk size: 2150
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute - OK! 15 cells [465 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.ExecuteArgs@3bbf0454
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 25227304 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 7
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute end
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute 1 - false
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: chunk: 1, from: 0, size: 2150
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: query: with set [measureSet] as '{[Measures].[Store Sales]}' set [columnSet] as '{[measureSet]}' set [set_0_set] as '{Union({[Promotion Media].[Promotion Media].[All Media]}, [Promotion Media].[Promotion Media].levels(1).AllMembers)}' set [rowHierarchiesSet] as '{Filter([set_0_set], not (isEmpty([Measures].[Store Sales])))}' set [rowSet] as '{[rowHierarchiesSet]}' member [Promotions].[Promotions].[All Promotions].[(Total)] as 'Aggregate({[Promotions].[Promotions].[Big Promo],[Promotions].[Promotions].[Big Time Discounts],[Promotions].[Promotions].[Big Time Savings],[Promotions].[Promotions].[Bye Bye Baby],[Promotions].[Promotions].[Cash Register Lottery],[Promotions].[Promotions].[Coupon Spectacular],[Promotions].[Promotions].[Dimes Off],[Promotions].[Promotions].[Dollar Cutters],[Promotions].[Promotions].[Dollar Days],[Promotions].[Promotions].[Double Down Sale],[Promotions].[Promotions].[Double Your Savings],[Promotions].[Promotions].[Fantastic Discounts],[Promotions].[Promotions].[Free For All],[Promotions].[Promotions].[Go For It],[Promotions].[Promotions].[Green Light Days],[Promotions].[Promotions].[Green Light Special],[Promotions].[Promotions].[High Roller Savings],[Promotions].[Promotions].[I Cant Believe It Sale],[Promotions].[Promotions].[Money Grabbers],[Promotions].[Promotions].[Money Savers],[Promotions].[Promotions].[Mystery Sale],[Promotions].[Promotions].[No Promotion],[Promotions].[Promotions].[One Day Sale],[Promotions].[Promotions].[Pick Your Savings],[Promotions].[Promotions].[Price Cutters],[Promotions].[Promotions].[Price Destroyers],[Promotions].[Promotions].[Price Savers],[Promotions].[Promotions].[Price Slashers],[Promotions].[Promotions].[Price Smashers],[Promotions].[Promotions].[Price Winners],[Promotions].[Promotions].[Sale Winners],[Promotions].[Promotions].[Sales Days],[Promotions].[Promotions].[Sales Galore],[Promotions].[Promotions].[Save-It Sale],[Promotions].[Promotions].[Saving Days],[Promotions].[Promotions].[Savings Galore],[Promotions].[Promotions].[Shelf Clearing Days],[Promotions].[Promotions].[Shelf Emptiers],[Promotions].[Promotions].[Super Duper Savers],[Promotions].[Promotions].[Super Savers],[Promotions].[Promotions].[Super Wallet Savers],[Promotions].[Promotions].[Three for One],[Promotions].[Promotions].[Tip Top Savings],[Promotions].[Promotions].[Two Day Sale],[Promotions].[Promotions].[Two for One],[Promotions].[Promotions].[Unbeatable Price Savers],[Promotions].[Promotions].[Wallet Savers],[Promotions].[Promotions].[Weekend Markdown],[Promotions].[Promotions].[You Save Days]})' Select NON EMPTY [columnSet] DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , NON EMPTY Subset([rowSet], 0, 2150) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM [Sales] where ([Promotions].[Promotions].[All Promotions].[(Total)]) CELL PROPERTIES VALUE
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute - duration: 21
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute - set chunk size: 2365
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute - OK! 15 cells [21 ms]
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.ExecuteArgs@aa88473
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 21116984 / 0
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 8
jul 10, 2018 10:24:36 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute end
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute 2 - false
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: chunk: 2, from: 2150, size: 2365
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: query: with set [measureSet] as '{[Measures].[Store Sales]}' set [columnSet] as '{[measureSet]}' set [set_0_set] as '{Union({[Promotion Media].[Promotion Media].[All Media]}, [Promotion Media].[Promotion Media].levels(1).AllMembers)}' set [rowHierarchiesSet] as '{Filter([set_0_set], not (isEmpty([Measures].[Store Sales])))}' set [rowSet] as '{[rowHierarchiesSet]}' member [Promotions].[Promotions].[All Promotions].[(Total)] as 'Aggregate({[Promotions].[Promotions].[Big Promo],[Promotions].[Promotions].[Big Time Discounts],[Promotions].[Promotions].[Big Time Savings],[Promotions].[Promotions].[Bye Bye Baby],[Promotions].[Promotions].[Cash Register Lottery],[Promotions].[Promotions].[Coupon Spectacular],[Promotions].[Promotions].[Dimes Off],[Promotions].[Promotions].[Dollar Cutters],[Promotions].[Promotions].[Dollar Days],[Promotions].[Promotions].[Double Down Sale],[Promotions].[Promotions].[Double Your Savings],[Promotions].[Promotions].[Fantastic Discounts],[Promotions].[Promotions].[Free For All],[Promotions].[Promotions].[Go For It],[Promotions].[Promotions].[Green Light Days],[Promotions].[Promotions].[Green Light Special],[Promotions].[Promotions].[High Roller Savings],[Promotions].[Promotions].[I Cant Believe It Sale],[Promotions].[Promotions].[Money Grabbers],[Promotions].[Promotions].[Money Savers],[Promotions].[Promotions].[Mystery Sale],[Promotions].[Promotions].[No Promotion],[Promotions].[Promotions].[One Day Sale],[Promotions].[Promotions].[Pick Your Savings],[Promotions].[Promotions].[Price Cutters],[Promotions].[Promotions].[Price Destroyers],[Promotions].[Promotions].[Price Savers],[Promotions].[Promotions].[Price Slashers],[Promotions].[Promotions].[Price Smashers],[Promotions].[Promotions].[Price Winners],[Promotions].[Promotions].[Sale Winners],[Promotions].[Promotions].[Sales Days],[Promotions].[Promotions].[Sales Galore],[Promotions].[Promotions].[Save-It Sale],[Promotions].[Promotions].[Saving Days],[Promotions].[Promotions].[Savings Galore],[Promotions].[Promotions].[Shelf Clearing Days],[Promotions].[Promotions].[Shelf Emptiers],[Promotions].[Promotions].[Super Duper Savers],[Promotions].[Promotions].[Super Savers],[Promotions].[Promotions].[Super Wallet Savers],[Promotions].[Promotions].[Three for One],[Promotions].[Promotions].[Tip Top Savings],[Promotions].[Promotions].[Two Day Sale],[Promotions].[Promotions].[Two for One],[Promotions].[Promotions].[Unbeatable Price Savers],[Promotions].[Promotions].[Wallet Savers],[Promotions].[Promotions].[Weekend Markdown],[Promotions].[Promotions].[You Save Days]})' Select NON EMPTY [columnSet] DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , NON EMPTY Subset([rowSet], 2150, 2365) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM [Sales] where ([Promotions].[Promotions].[All Promotions].[(Total)]) CELL PROPERTIES VALUE
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute - empty [12 ms]
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Add - com.flexmonster.proxy.vo.args.ExecuteArgs@d9920492
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Memory - 25187824 / 0
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.utils.CacheManager add
INFORMAÇÕES: CACHE: Items is cache: 9
jul 10, 2018 10:24:37 AM com.flexmonster.proxy.FlexmonsterProxyServlet execute
INFORMAÇÕES: Execute end
jul 10, 2018 10:24:39 AM com.flexmonster.proxy.FlexmonsterProxyServlet drillThrough
INFORMAÇÕES: Drill through...
jul 10, 2018 10:24:39 AM com.flexmonster.proxy.FlexmonsterProxyServlet drillThrough
INFORMAÇÕES: DRILLTHROUGH SELECT {[Measures].[Store Sales]} ON columns FROM [Sales] WHERE ([Promotion Media].[Promotion Media].[No Media],[Promotions].[Promotions].[Big Promo],[Promotions].[Promotions].[Big Time Discounts],[Promotions].[Promotions].[Big Time Savings],[Promotions].[Promotions].[Bye Bye Baby],[Promotions].[Promotions].[Cash Register Lottery],[Promotions].[Promotions].[Coupon Spectacular],[Promotions].[Promotions].[Dimes Off],[Promotions].[Promotions].[Dollar Cutters],[Promotions].[Promotions].[Dollar Days],[Promotions].[Promotions].[Double Down Sale],[Promotions].[Promotions].[Double Your Savings],[Promotions].[Promotions].[Fantastic Discounts],[Promotions].[Promotions].[Free For All],[Promotions].[Promotions].[Go For It],[Promotions].[Promotions].[Green Light Days],[Promotions].[Promotions].[Green Light Special],[Promotions].[Promotions].[High Roller Savings],[Promotions].[Promotions].[I Cant Believe It Sale],[Promotions].[Promotions].[Money Grabbers],[Promotions].[Promotions].[Money Savers],[Promotions].[Promotions].[Mystery Sale],[Promotions].[Promotions].[No Promotion],[Promotions].[Promotions].[One Day Sale],[Promotions].[Promotions].[Pick Your Savings],[Promotions].[Promotions].[Price Cutters],[Promotions].[Promotions].[Price Destroyers],[Promotions].[Promotions].[Price Savers],[Promotions].[Promotions].[Price Slashers],[Promotions].[Promotions].[Price Smashers],[Promotions].[Promotions].[Price Winners],[Promotions].[Promotions].[Sale Winners],[Promotions].[Promotions].[Sales Days],[Promotions].[Promotions].[Sales Galore],[Promotions].[Promotions].[Save-It Sale],[Promotions].[Promotions].[Saving Days],[Promotions].[Promotions].[Savings Galore],[Promotions].[Promotions].[Shelf Clearing Days],[Promotions].[Promotions].[Shelf Emptiers],[Promotions].[Promotions].[Super Duper Savers],[Promotions].[Promotions].[Super Savers],[Promotions].[Promotions].[Super Wallet Savers],[Promotions].[Promotions].[Three for One],[Promotions].[Promotions].[Tip Top Savings],[Promotions].[Promotions].[Two Day Sale],[Promotions].[Promotions].[Two for One],[Promotions].[Promotions].[Unbeatable Price Savers],[Promotions].[Promotions].[Wallet Savers],[Promotions].[Promotions].[Weekend Markdown],[Promotions].[Promotions].[You Save Days])
jul 10, 2018 10:24:39 AM com.flexmonster.proxy.FlexmonsterProxyServlet drillThrough
GRAVE: mondrian gave exception while parsing query
org.olap4j.OlapException: mondrian gave exception while parsing query
 at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:842)
 at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:84)
 at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65)
 at com.flexmonster.proxy.FlexmonsterProxyServletImpl.getDrillThrough(FlexmonsterProxyServletImpl.java:206)
 at com.flexmonster.proxy.FlexmonsterProxyServlet.drillThrough(FlexmonsterProxyServlet.java:688)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:151)
 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:171)
 at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:195)
 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:104)
 at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:406)
 at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:350)
 at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:106)
 at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:259)
 at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
 at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
 at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
 at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
 at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
 at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:320)
 at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:236)
 at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1028)
 at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:373)
 at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:381)
 at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:344)
 at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:219)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
 at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
 at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:256)
 at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:219)
 at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:499)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Unknown Source)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'DRILLTHROUGH SELECT {[Measures].[Store Sales]} ON columns FROM [Sales] WHERE ([Promotion Media].[Promotion Media].[No Media],[Promotions].[Promotions].[Big Promo],[Promotions].[Promotions].[Big Time Discounts],[Promotions].[Promotions].[Big Time Savings],[Promotions].[Promotions].[Bye Bye Baby],[Promotions].[Promotions].[Cash Register Lottery],[Promotions].[Promotions].[Coupon Spectacular],[Promotions].[Promotions].[Dimes Off],[Promotions].[Promotions].[Dollar Cutters],[Promotions].[Promotions].[Dollar Days],[Promotions].[Promotions].[Double Down Sale],[Promotions].[Promotions].[Double Your Savings],[Promotions].[Promotions].[Fantastic Discounts],[Promotions].[Promotions].[Free For All],[Promotions].[Promotions].[Go For It],[Promotions].[Promotions].[Green Light Days],[Promotions].[Promotions].[Green Light Special],[Promotions].[Promotions].[High Roller Savings],[Promotions].[Promotions].[I Cant Believe It Sale],[Promotions].[Promotions].[Money Grabbers],[Promotions].[Promotions].[Money Savers],[Promotions].[Promotions].[Mystery Sale],[Promotions].[Promotions].[No Promotion],[Promotions].[Promotions].[One Day Sale],[Promotions].[Promotions].[Pick Your Savings],[Promotions].[Promotions].[Price Cutters],[Promotions].[Promotions].[Price Destroyers],[Promotions].[Promotions].[Price Savers],[Promotions].[Promotions].[Price Slashers],[Promotions].[Promotions].[Price Smashers],[Promotions].[Promotions].[Price Winners],[Promotions].[Promotions].[Sale Winners],[Promotions].[Promotions].[Sales Days],[Promotions].[Promotions].[Sales Galore],[Promotions].[Promotions].[Save-It Sale],[Promotions].[Promotions].[Saving Days],[Promotions].[Promotions].[Savings Galore],[Promotions].[Promotions].[Shelf Clearing Days],[Promotions].[Promotions].[Shelf Emptiers],[Promotions].[Promotions].[Super Duper Savers],[Promotions].[Promotions].[Super Savers],[Promotions].[Promotions].[Super Wallet Savers],[Promotions].[Promotions].[Three for One],[Promotions].[Promotions].[Tip Top Savings],[Promotions].[Promotions].[Two Day Sale],[Promotions].[Promotions].[Two for One],[Promotions].[Promotions].[Unbeatable Price Savers],[Promotions].[Promotions].[Wallet Savers],[Promotions].[Promotions].[Weekend Markdown],[Promotions].[Promotions].[You Save Days])'
 at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
 at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100)
 at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:588)
 at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:81)
 ... 48 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Promotions].[Promotions]'.
 at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:989)
 at mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:199)
 at mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:71)
 at mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:243)
 at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:105)
 at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
 at mondrian.olap.QueryAxis.validate(QueryAxis.java:291)
 at mondrian.olap.Query.resolve(Query.java:584)
 at mondrian.olap.Query.resolve(Query.java:445)
 at mondrian.olap.Query.<init>(Query.java:199)
 at mondrian.olap.Query.<init>(Query.java:160)
 at mondrian.parser.QueryPartFactoryImpl.makeQuery(QueryPartFactoryImpl.java:38)
 at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241)
 at mondrian.parser.MdxParserImpl.drillthroughStatement(MdxParserImpl.java:1488)
 at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1077)
 at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
 at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
 at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96)
 ... 50 more

2 answers

Public

Dmytro Zvazhii ⋅ Flexmonster ⋅ July 10, 2018

Hello Gabriel,
Thank you for your question. We have managed to reproduce the issue on our side. Our devs need to spend some more time on the investigation.
We will notify you of the results ETA Jul 30.
Regards,
Dmytro

Public

Dmytro Zvazhii ⋅ Flexmonster ⋅ July 30, 2018

Hello Gabriel,
We are glad to inform you that the version with the fix has already been released.
You are welcome to update the component.
Regards,
Dmytro

DRILLTHROUGH with filter

2 answers

Please login or Register to Submit Answer