Output from session.visualize() using the atoti Python library is producing .00 return values when rapidly clicking drop-down items

[andrewyang94]

Hi, while using the atoti Python library and running the introduction-to-atoti notebook file in JupyterLab, I witnessed a bug that seems to occur when I click a drop-down item in the resulting atoti output visualization for session.visualize(). It looks like when you rapidly click around on a drop-down item, return values get cleared out as .00. I've attached a short clip of what this looks like.

atoti-viz-output-bug.mov

Steps to reproduce

To reproduce I execute the following:

$ cd atoti
$ jupyter-lab

Then proceed to run the notebook file at 01-atoti-academy/introduction-to-atoti/main.ipynb. This occurs for the specific cells right after 6.3.2.4.1 Origin scope.

Actual Result

When clicking around in the resulting notebook output for session.visualize() for drop-down items, return values get cleared out as .00.

Expected Result

I would expect to be able to click (and re-click) through drop-down items in the resulting Atoti visualization that allows me to see the underlying data.

Environment

• atoti: 0.8.7
• Python: 3.10.13
• Operating System: macOS 14.1.1

Some additional info:

$ python --version
Python 3.10.13

$ pip list | grep atoti
atoti                     0.8.7
atoti-aws                 0.8.7
atoti-core                0.8.7
atoti-jupyterlab          0.8.7
atoti-query               0.8.7

$ jupyter-lab --version
4.0.9

Logs (if relevant)

Logs obtained from my local environment at /Users/aya/.atoti/1703186119_D24CLL/logs/server.log:

2023-12-21 14:57:27.534  INFO 88549 --- [Thread-1] i.a.pivot.measure.MeasureManagerImpl     : Redefining measure Profit
2023-12-21 14:57:27.536  INFO 88549 --- [Thread-1] io.atoti.impl.SimpleManager              : Update cube transaction is started.
2023-12-21 14:57:27.547  WARN 88549 --- [Thread-1] c.qfs.multiversion.impl.VersionHistory   : The version of datastore-1 at the epoch 92 was not marked. Marked epochs are: {}
2023-12-21 14:57:27.552  WARN 88549 --- [Thread-1] c.qfs.multiversion.impl.VersionHistory   : The version of datastore-1 at the epoch 94 was not marked. Marked epochs are: {}
2023-12-21 14:57:28.594  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [jvm, memory] INFO 2023-12-21T19:57:28.593Z uptime=2528823ms com.activeviam.health.monitor.impl.JvmHealthCheck.createEvent:60 thread=activeviam-health-check-worker thread_id=43 event_type=JvmMemoryReport JVM Memory Usage report: G1 Young Generation[count=12 (+0), time=0s (+0)]  G1 Old Generation[count=0 (+0), time=0s (+0)]  Heap[used=561 MiB 547 KiB (588811264) (+(0)), committed=1 GiB (1073741824) (+(0)), max=10 GiB (10737418240) (+(0))]  Direct[used=94 MiB 753 KiB (99337968) (+7 MiB 512 KiB (7864320)), count=539 (+30), max=10 GiB (10737418240) (+(0))]  Threads[count=75 (+0), peak=90 (+0)]
2023-12-21 14:57:29.067  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, realtime, query] INFO 2023-12-21T19:57:29.067Z uptime=2529297ms com.quartetfs.biz.pivot.streaming.impl.AActivePivotStream.transitionState:288 thread=http-nio-9092-exec-2 thread_id=45 event_type=ActivePivotContinuousQueryUnregistered user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] Unregistered  query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]]
2023-12-21 14:57:29.124  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, realtime, query] INFO 2023-12-21T19:57:29.123Z uptime=2529353ms com.quartetfs.biz.pivot.streaming.impl.AActivePivotStream.transitionState:286 thread=http-nio-9092-exec-3 thread_id=46 event_type=ActivePivotContinuousQueryUnregistered user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] Unregistered  query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]]
2023-12-21 14:57:29.129  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:29.129Z uptime=2529359ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-pool-1-query-worker-21 thread_id=175 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=GetAggregatesQuery [pivotId=Order Cube, locations={AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\[*], AllMember\2019-02-15|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\[*], AllMember\2019-02-15|AllMember|AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\Guaraná Fantástica}, measureSelection=[_ProfitPerUnit (sum), Quantity Sold.SUM, Profit], additionalMeasures=[], contextValues=null] execution_time=4ms
2023-12-21 14:57:29.130  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:29.130Z uptime=2529360ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-common-pool-worker-38 thread_id=222 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=ActivePivotSyncActionQuery: action=MdxActionWithResult (mdx=SELECT   NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,   NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS  FROM [Order Cube]  CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@ca50dc2 execution_time=7ms
2023-12-21 14:57:29.172  INFO 88549 --- [http-nio-9092-exec-5] i.a.p.r.w.i.WidgetsRestServiceController : notebook widget 1c6e5cfc-0c25-46eb-b6d9-188123a00c6f done loading
2023-12-21 14:57:49.565  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, realtime, query] INFO 2023-12-21T19:57:49.565Z uptime=2549795ms com.quartetfs.biz.pivot.streaming.impl.AActivePivotStream.updateQuery:120 thread=http-nio-9092-exec-7 thread_id=50 event_type=ActivePivotContinuousQueryUpdated user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] Updated  new_query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))), Crossjoin([Orders].[Order Date].[ALL].[AllMember].[2019-02-15], [Products].[Product Tree].[ALL].[AllMember].[Beverages].[Chai], Hierarchize(Descendants({[Orders].[Order Id].[ALL].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]] old_query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]]
2023-12-21 14:57:49.568  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:49.568Z uptime=2549798ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-pool-1-query-worker-31 thread_id=199 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=GetAggregatesQuery [pivotId=Order Cube, locations={AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\[*], AllMember\2019-02-15|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\[*], AllMember\2019-02-15|AllMember|AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\[Guaraná Fantástica, Chai]}, measureSelection=[_ProfitPerUnit (sum), Quantity Sold.SUM, Profit], additionalMeasures=[], contextValues=null] execution_time=2ms
2023-12-21 14:57:49.569  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:49.569Z uptime=2549799ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-common-pool-worker-38 thread_id=222 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=ActivePivotSyncActionQuery: action=MdxActionWithResult (mdx=SELECT   NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,   NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))), Crossjoin([Orders].[Order Date].[ALL].[AllMember].[2019-02-15], [Products].[Product Tree].[ALL].[AllMember].[Beverages].[Chai], Hierarchize(Descendants({[Orders].[Order Id].[ALL].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS  FROM [Order Cube]  CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@31125a43 execution_time=4ms
2023-12-21 14:57:50.063  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, realtime, query] INFO 2023-12-21T19:57:50.062Z uptime=2550292ms com.quartetfs.biz.pivot.streaming.impl.AActivePivotStream.updateQuery:120 thread=http-nio-9092-exec-8 thread_id=51 event_type=ActivePivotContinuousQueryUpdated user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] Updated  new_query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]] old_query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))), Crossjoin([Orders].[Order Date].[ALL].[AllMember].[2019-02-15], [Products].[Product Tree].[ALL].[AllMember].[Beverages].[Chai], Hierarchize(Descendants({[Orders].[Order Id].[ALL].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]]
2023-12-21 14:57:50.069  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:50.068Z uptime=2550298ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-pool-1-query-worker-25 thread_id=179 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=GetAggregatesQuery [pivotId=Order Cube, locations={AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\[*], AllMember\2019-02-15|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\[*], AllMember\2019-02-15|AllMember|AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\Guaraná Fantástica}, measureSelection=[_ProfitPerUnit (sum), Quantity Sold.SUM, Profit], additionalMeasures=[], contextValues=null] execution_time=4ms
2023-12-21 14:57:50.070  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:50.070Z uptime=2550300ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-common-pool-worker-38 thread_id=222 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=ActivePivotSyncActionQuery: action=MdxActionWithResult (mdx=SELECT   NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,   NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS  FROM [Order Cube]  CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@32aa6e9 execution_time=8ms
2023-12-21 14:57:50.672  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, realtime, query] INFO 2023-12-21T19:57:50.672Z uptime=2550902ms com.quartetfs.biz.pivot.streaming.impl.AActivePivotStream.updateQuery:120 thread=http-nio-9092-exec-9 thread_id=52 event_type=ActivePivotContinuousQueryUpdated user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] Updated  new_query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))), Crossjoin([Orders].[Order Date].[ALL].[AllMember].[2019-02-15], [Products].[Product Tree].[ALL].[AllMember].[Beverages].[Chai], Hierarchize(Descendants({[Orders].[Order Id].[ALL].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]] old_query=MdxQuery [mdx=SELECT
  NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS
 FROM [Order Cube]
 CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS, cellsOnly=false, contextValues=[MdxContext [repository={ancestorCaptionOnSlicer=true}]]]
2023-12-21 14:57:50.679  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:50.678Z uptime=2550908ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-pool-1-query-worker-28 thread_id=182 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=GetAggregatesQuery [pivotId=Order Cube, locations={AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember, AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\[*], AllMember\2019-02-15|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\[*], AllMember\2019-02-15|AllMember|AllMember\[*]|AllMember|AllMember|AllMember|AllMember|AllMember|AllMember\Beverages\[Guaraná Fantástica, Chai]}, measureSelection=[_ProfitPerUnit (sum), Quantity Sold.SUM, Profit], additionalMeasures=[], contextValues=null] execution_time=4ms
2023-12-21 14:57:50.680  INFO 88549 --- [activepivot-health-event-dispatcher] c.a.h.m.ILoggingHealthEventHandler       : [activepivot, query] INFO 2023-12-21T19:57:50.680Z uptime=2550910ms com.quartetfs.biz.pivot.impl.ActivePivotQueryManager$QueryExecutionTask.report:913 thread=activeviam-common-pool-worker-38 thread_id=222 event_type=ActivePivotQueryDone user=anonymousUser roles=[ROLE_ADMIN, ROLE_USER] query=ActivePivotSyncActionQuery: action=MdxActionWithResult (mdx=SELECT   NON EMPTY {[Measures].[_ProfitPerUnit (sum)], [Measures].[Quantity Sold.SUM], [Measures].[Profit]} DIMENSION PROPERTIES ANCESTOR_CAPTION ON COLUMNS,   NON EMPTY Hierarchize(Union(Crossjoin(Hierarchize(Descendants({[Orders].[Order Date].[AllMember]}, 1, SELF_AND_BEFORE)), Hierarchize(Descendants({[Products].[Product Tree].[AllMember]}, 1, SELF_AND_BEFORE)), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], Descendants({[Products].[Product Tree].[AllMember].[Beverages]}, [Products].[Product Tree].[ProductName]), [Orders].[Order Id].DefaultMember), Crossjoin([Orders].[Order Date].[AllMember].[2019-02-15], [Products].[Product Tree].[AllMember].[Beverages].[Guaraná Fantástica], Hierarchize(Descendants({[Orders].[Order Id].[AllMember]}, 1, SELF_AND_BEFORE))), Crossjoin([Orders].[Order Date].[ALL].[AllMember].[2019-02-15], [Products].[Product Tree].[ALL].[AllMember].[Beverages].[Chai], Hierarchize(Descendants({[Orders].[Order Id].[ALL].[AllMember]}, 1, SELF_AND_BEFORE))))) DIMENSION PROPERTIES ANCESTOR_CAPTION ON ROWS  FROM [Order Cube]  CELL PROPERTIES VALUE,FORMATTED_VALUE,BACK_COLOR,FORE_COLOR,FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@34f3bcbe execution_time=8ms

[tibdex]

I tried on the main branch of the internal repo and could not reproduce the problem on Chrome and Safari:

Screen.Recording.2023-12-22.at.10.36.48.mov

I'm also using JupyterLab 4.0.5 instead of your 4.0.9.

[andrewyang94]

I included comprehensive steps to reproduce, can you try the following? This should be my entire environment packaged up ready for debugging:

docker run -it -p 8888:8888 -p 9092:9092 andrewyang94/atoti-tutorial

Then, navigate to the JupyterLab URL and proceed with the introduction-to-atoti notebook file for specific cells right after 6.3.2.4.1 Origin scope. Also, just adding additional information, the Chrome browser on my host machine is as follows: Version 120.0.6099.129 (Official Build) (arm64)

Edit: I've also included another video (based on the above container) that showcases the error. Also note that this issue seems to only affect specific cells (I show in the video some other visualization drop-downs working).

Untitled.mov