News
Abstract
The following updates are available in release 2.0.95 of Planning Analytics Workspace.
Content
New synchronization settings allow customized display of hierarchies
New synchronization settings under Advanced synchronization now let you customize how each hierarchy in the cube viewer or visualization displays when a synchronization event is received by that widget.
You can find Advanced synchronization in the Properties > Synchronize > Hierarchies section when synchronization is enabled for the widget that receives the synchronization.
Note: The advanced synchronization settings apply to only the widget that receives the synchronization event.
The Advanced synchronization panel is divided into Row, Column, and Filters sections. You can choose what each hierarchy on the Row and Column areas displays when the widget receives a set change or member change synchronization event. You can select the hierarchy display for the Context area under Filters.
For a set change synchronization event, you can choose what you want the set in the receiving widget to display:
- Set - The set with all its members and children displays in the widget.
- Set and aggregate - The aggregate of the all the members in the set shows below the set.
- Aggregate and set - The aggregate of the all the members in the set shows above the set.
- Aggregate - Only the aggregate of all the members in the set displays in the widget.
- Member and children
- Member
- Children
- Member and descendants
- Descendants
- Member and parents
- Parents
- Member and ancestors
- Ancestors
The advanced synchronization settings persist if you move a hierarchy from to a different area in the widget.
If you're using an advanced selector widget to synchronize members, you can select multiple members and the receiving widget will display the set and members based on the synchronization settings you selected for that widget.
In the following example, advanced synchronization is set to Aggregate and set and Member and children for the model hierarchy on the Row. An advanced selector list for model is used to synchronize members. When the member is changed to L Series, the cube viewer updates to display an aggregate of all the members in the set and the set updates to display only the selected member and its children.
Create color-coded tags in plan tasks
You can create color-coded, custom tags in plan tasks to quickly identify tasks on the plan Overview page.
You can create tags when creating or editing a task.
To create and add a new tag to your task, follow these steps:
- On the Task details tab in a plan task, click into the Tags field and click Create new tag.
- In the Name field, enter a label for your tag.
- Choose a color for your tag. You can see what the tag will look like in the Preview field.
- Click Create.
- Expand the Tags field, select the tag that you just created to add it to the task.
Any tags that you create are saved to the plan. This means that all tasks in a plan can share the available tags in that same plan. Tasks can't access tags from other plans.
Click the Edit a tag icon next to a tag to edit or delete the tag.
Important: When you delete a tag, the tag is removed from all tasks in the plan that use the tag.
Enhancements to the File manager
The File manager tool on the modeling workbench features several enhancements in this release that lets you easily move files around. The File manager shows a list of all the files and folders that have been uploaded to the Planning Analytics database and allows you to manage those items.
The File manager in Planning Analytics Workspace now supports the following actions:
Create folders and subfolders
You can now create folders and subfolders in the File manager. If you delete a folder, subfolders or files in that folder are also deleted.
Cut, copy, and paste files
You can now move or copy files or folders to a different folder within the File manager. The Cut and Copy options display in the toolbar when you select one or more items.
To cut or copy, select one or more items and click Cut or Copy. Your selections display in alphabetical order as a horizontal list for a quick review before you cut or copy the items.
After you review the list of items that you want to cut or copy, you can paste the items to a different folder. To paste a cut or copied item, go to the destination folder and click Paste.
Compress and expand files
Select one or more files or folders and click Compress to compress the items into a .zip file. You can compress a file and move it to a new location without using Cut. To do this, select a file and click Compress. Then, go to the destination folder and click Compress again.
To expand a compressed file, select the file and click Expand. As with compressing a file to a new location, you can expand a file to a new folder.
Revert transactions in the transaction log
You can now revert one or more transactions from the database transaction log in Planning Analytics Workspace.
- Open the transaction log from the Databases tree on a modeling workbench.
- To open the transaction log at the database level, right-click a database, then click Logs > Transaction log.
- To open the transaction log for an individual cube, right-click the cube, then click Logs > Transaction log.
- Set filtering options if desired. You can also click any column heading to sort transactions.
- Select the transactions you want to revert.
- Click Revert.
- Click OK to confirm the action.
The current cell value is reverted to the value indicated by the Prior value column. If multiple selections target the same cell, the transaction selected last takes precedence.
Manage database thread activity on the modeling workbench
You can now view and manage thread activity for a database directly on the modeling workbench.
This new feature provides many of the same capabilities available for thread monitoring in Planning Analytics Administration.
To monitor thread activity on a Planning Analytics database, right-click the database on the Databases tree, then click Threads.
To monitor thread activity on Planning Analytics Engine, right-click the database on the Databases tree, then click Activity.
The thread monitor displays all threads on the database using these sortable columns:
Name
The name of the user who initiated the thread.
State
- Idle: not using resources
- Wait: waiting on other threads, blocked
- Running
- Commit: committing updates made by a thread
- Rollback: rolling back to a state before an update
- Login: when a user logs in and initiates a thread
Type
Indicates a User or System thread.
Function
The API function being executed by the thread.
Wait
The length of time, in seconds, that the thread has been in a wait state.
Elapsed
The total elapsed time of the thread in its current state.
W/R/Ix locks
A write lock allows only the thread that holds the lock to access and write changes to an object. No other thread can read or modify the object until the W lock has been released.
A read lock allows many threads to read from an object at the same time, but does not allow another thread to modify or write to the object until all R locks have been released.
An intent-to-write lock reserves the right for a thread to obtain a write lock on an object when all read locks have been released. Only one thread at a time is allowed to have an Ix lock on an object.
Context
The connected Planning Analytics client that is associated with the thread.
To cancel an individual thread, click the Cancel thread icon adjacent to the final column on the report, then confirm the action.
To cancel multiple threads:
- Click Pause. When monitoring is paused, check boxes are available to select individual threads.
- Select the threads you want to cancel.
- Click Cancel threads on the toolbar, then confirm the action.
- Click Resume to resume thread monitoring.
Deprecation notices
End of support for Planning Analytics Workspace Local on Red Hat Enterprise Linux 7 (Local only)
Planning Analytics Workspace Local versions 2.0.70 and later are supported on Red Hat Enterprise Linux version 8.
Planning Analytics Workspace Local versions 2.0.93 and later are supported on Red Hat Enterprise Linux version 9.
End of support for Planning Analytics Workspace Local on Windows Server 2016 (Local only)
Planning Analytics Workspace Local versions 2.0.74 and later are supported on Windows Server 2019.
Was this topic helpful?
Document Information
Modified date:
26 April 2024
UID
ibm17148297