SUMMARY:
This issue has been classified as a defect by Strategy. The impact is limited to Strategy Developer 9.4.x products only using the Intelligent Cube Monitor.No workarounds are currently available in the current document. A solution/code fix for this issue is not available in current releases but is being reviewed for a future Strategy release.
SYMPTOM:
In Strategy Developer inside the Intelligent Cube Monitor if a user is sorting by Intelligent Cube Instance IDs or Intelligent Cube Definition IDs the column will not sort in ascending or descending order as shown below.
Intelligent Cube Instance IDs
Intelligent Cube Definition IDs
STEPS TO REPRODUCE:
1. Load multiple Cubes into memory on a single Strategy Intelligence Server
2. Navigate to the Project Source -> Administration-> System Monitors -> Caches-> Intelligent Cubes
3. Attempt to sort Ascending or Descending on either Intelligent Cube Instance IDs or Intelligent Cube Definition IDs columns
Video:
You can find a detailed video on how this issue is reproduced here: Tech Note 45736. Steps to reproduce
CAUSE:
This issue occurs if the Cube Instance IDs and Intelligent Cube Definition IDs columns are clicked in the cube monitor. This is a known issue classified as a defect with Strategy Developer 9.x..
ACTION:
Contact Strategy Technical Support for an update on the status of the issue. Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
ADDITIONAL TROUBLESHOOTING:
If the workaround steps above do not resolve the issue, please consider calling Strategy technical support with the following information of troubleshooting already done:
1. A screen shot of the cubes loaded into memory to see how the sort is behaving.
2. Version of Strategy with Hotfix of Intelligence Server and Developer.
TO LEARN MORE:
KB33163 - Even though the Intelligent Cube is already active, the Intelligent Cube monitor in Strategy Desktop 9.0.0 shows the Activate option instead of the Deactivate option
KB31352 - How does Intelligent Cube caching work in a clustered Strategy 9.x environment
KB45552 - Multiple copies of Intelligent Cube instances appear when a cluster node is restarts in Strategy 9.3.1
