Unable to Edit DBRW / DBHW Formula

Arc & Slice
1

Error when trying edit either DBRW or DBHW in a Slice report, for example replacing hardcoded hierarchy name, or simply removing and replacing existing cell reference .

Tried:

  • Removing ArcForTM1 folder and reestablishing
  • Removing virtual hierarchies
  • Simple cube (works as expected)

Version: Slice 4.6.1.0
Arc: 4.6.1

Steps to reproduce:

  1. Export specific cube view to new workbook
  2. Rebuild sheet, execute successfully
  3. Edit formula via formula bar
  4. Either Tab, or Enter, to exit edit
  5. This causes Slice to hang, ultimately requiring Excel to be terminated.

Logs (Failed step)
2025-04-08 14:11:04.9902 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:04.9902 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:04.9902 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0002 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0146 Debug ExecuteAsync Resource: ExecuteMDXSetExpression
2025-04-08 14:11:05.0843 Info Executed mdx set expression query in 88ms with 1 elements. MDX: {[period].[period].[allperiods]}
2025-04-08 14:11:05.0843 Info Executed mdx set expression query in 100ms with 1 elements. MDX: {[version].[version].[actual]}
2025-04-08 14:11:05.2069 Info Executed mdx set expression query in 208ms with 1 elements. MDX: {[company].[company].[allcompanies]}
2025-04-08 14:11:05.4616 Info Executed mdx set expression query in 455ms with 1 elements. MDX: {[product].[product].[allproducts]}
2025-04-08 14:11:05.6504 Info Executed mdx set expression query in 642ms with 1 elements. MDX: {[distance].[distance].[alldistances]}
2025-04-08 14:11:05.8338 Info Executed mdx set expression query in 821ms with 1 elements. MDX: {[currency].[currency].[allcurrencies]}
2025-04-08 14:11:05.9927 Debug 1 queries failed

2

Hi @jrob ,

We need more information, could you please create a ticket: Issues · Cubewise CODE / Arc and Slice · GitLab

Please send us the spreadsheet.

Cheers,

Vincent

3

Done, thanks.