{"type":"doc","content":[{"type":"panel","attrs":{"panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Welcome to our training materials! We're excited to have you here and hope that this training will provide you with valuable knowledge and skills. Below, you can find the complete table of contents, this will give you an overview of what topics will be covered and in what order. Be sure to check back regularly for any updates, as we make changes or additions to the training materials.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0747a6"}}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a7fabd65-b8c7-4729-bb09-836cee56dfae"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"26435ca1-f6e8-439d-bbef-22761392e3eb"}},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Working with Subset Editor ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Open Subset editor from different levels of the app ","type":"text"}]},{"type":"paragraph","content":[{"text":"Navigate to Exec Dashboard. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The subset editor is accessible from: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Filter bar ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Widget header for every available row or column dimension in each widget ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cube Settings popup","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 1 page 2-Settings popup.mp4","id":"90c5a64a-7051-4d84-9878-02a14a294df8","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Subset editor shortcut can be also added to the context menu which is useful functionality when editing views. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"decisionList","attrs":{"localId":"c9cd3a47-bd79-49b7-a10a-08c0074e0fcd"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"8a2ec0a4-9826-4d7c-a1ca-200171c55caa"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"Reports / Views - Simple planning template ","type":"text","marks":[{"type":"em"}]},{"text":"view ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable the edit mode ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the cube setting icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced option GUI for the","type":"text"},{"text":" Dimensions Settings ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Turn on ","type":"text"},{"text":"Enable Subset Editor","type":"text","marks":[{"type":"em"}]},{"text":" option ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 2 page 2-subset Editor option.mp4","id":"c05ac12c-a73a-4b05-aad8-926a5353f9c6","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on any element from ","type":"text"},{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Notice the the ","type":"text"},{"text":"Subset Editor ","type":"text","marks":[{"type":"em"}]},{"text":"option is available in the context menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate back to","type":"text"},{"text":" Exec Dashboard ","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 3 page 2 - Exec dashboard.mp4","id":"8b088451-a0c0-44eb-a6c5-2774a0f368d7","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2. Subset Selection ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"ae3ad0b2-b871-4790-84e7-ad2a93a0ec5b"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"f21c4006-0e8b-4858-b9a7-1452f09a7d5f"},"content":[{"text":"Open Subset editor for Overview widget Region dimension directly form its header.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change subset selection by opening the ","type":"text"},{"text":"Subset ","type":"text","marks":[{"type":"em"}]},{"text":"drop-down list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click through the available options to see how the displayed elements change ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Your choice is immediately visible and you can decide if those are the elements you want to display. The list includes Static and Private subsets. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 4 page 2-Private subsets.mp4","id":"be4a9d48-152d-4ec0-9622-edca7441dfd5","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"decisionList","attrs":{"localId":"bdb8a539-bd3a-4e55-8354-4e2dd38addc9"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"8aee3501-954c-4554-a90d-562f777a3403"},"content":[{"text":"Create your own subset ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Europe and Asia element","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use Keep button to confirm the selection","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Save ","type":"text","marks":[{"type":"em"}]},{"text":"icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the popup input: ","type":"text"},{"text":"my test subset ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Save ","type":"text","marks":[{"type":"em"}]},{"text":"button","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"New Subset will be now available in the Subset drop-down list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"to see the changes in the Overview widget ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Discard the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 5 page 2-Discard the changes.mp4","id":"29dbe9b1-4435-460c-8a33-29168c55a674","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"If you want to make additional adjustments it's possible to copy & paste and change the order of the elements.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"3. Attribute Selection ","type":"text"}]},{"type":"paragraph","content":[{"text":"Now you will practice Attribute selection.","type":"text"}]},{"type":"decisionList","attrs":{"localId":"0709a0e7-104b-4a70-a9e4-9101d177179d"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"e8b43c5e-1743-49cb-889f-4dea24e17285"},"content":[{"text":"Follow the steps ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open ","type":"text"},{"text":"Subset Editor","type":"text","marks":[{"type":"em"}]},{"text":" for Overview widget Region dimension directly form its header","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open ","type":"text"},{"text":"Attribute ","type":"text","marks":[{"type":"em"}]},{"text":"drop-down list to see all available attributes for selected dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose ","type":"text"},{"text":"Color ","type":"text","marks":[{"type":"em"}]},{"text":"and ","type":"text"},{"text":"Currency ","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"paragraph","content":[{"text":"Like in previous case you immediately can see how given attribute will look like if it was applied. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open ","type":"text"},{"text":"Attribute ","type":"text","marks":[{"type":"em"}]},{"text":"list again ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Unselect ","type":"text"},{"text":"Code and Description ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"to see the changes in the Overview widget ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 6 page 2-Overview widget.mp4","id":"ce4e0af8-e07e-4411-b9c4-30812eabf288","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Click ","type":"text","marks":[{"type":"strong"}]},{"text":"Save & Discard ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"button and ","type":"text","marks":[{"type":"strong"}]},{"text":"Discard changes ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"in the confirmation popup to revert to original configuration. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"4. Choose Default Value ","type":"text"}]},{"type":"paragraph","content":[{"text":"Subset editor also allows you to change default values for global filters and fixed values. ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"39d4a63b-648a-44cd-8ba9-21a75f28d2df"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"0bf933fc-e63f-4ffb-8240-f34fd7ca8931"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open ","type":"text"},{"text":"Subset Editor","type":"text","marks":[{"type":"em"}]},{"text":" for Region global filter ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Current default value is set to: ","type":"text"},{"text":"World ","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"decisionList","attrs":{"localId":"78b0e260-4a8e-46c2-a295-72bb00d8a658"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"6fd20694-c63a-46ed-9aba-60fdc710af55"},"content":[{"text":"You can easily change that","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Go through the elements visible in the dimension and notice that cursor icon appears ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you hover over it, the","type":"text"},{"text":" Select default","type":"text","marks":[{"type":"em"}]},{"text":" message will appear ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Europe","type":"text","marks":[{"type":"em"}]},{"text":" as ","type":"text"},{"text":"Default","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes and reload the page ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Turn on the Edit Mode ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Region filter should be displaying ","type":"text","marks":[{"type":"strong"}]},{"text":"Europe ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"element. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 7 page 2-Europe element.mp4","id":"5ad9117b-82d7-48ec-a55c-9d95e592780b","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"You can decide to remove default element by clicking \"x\" visible next to the selected element.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"5. Exercise ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this exercise you will use Subset Editor to change elements displayed in Version dimension. ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"06cb79c9-21cf-49a5-931f-4fd000ebeced"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"0fddba7a-aae3-4880-94da-b94c301013d2"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open ","type":"text"},{"text":"Subset Editor ","type":"text","marks":[{"type":"em"}]},{"text":"for Overview widget directly from its header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"em"}]},{"text":"from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Actual, Budget ","type":"text","marks":[{"type":"em"}]},{"text":"and ","type":"text"},{"text":"Act_Bud_Var","type":"text","marks":[{"type":"em"}]},{"text":" from the list by pressing and holding Ctrl to select multiple items ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Keep","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"button","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Overview widget is now displaying updated column elements selection. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 8 page 2-elements selection.mp4","id":"0261ef91-518b-4711-8bbd-b0b97e45afc7","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open cube settings for Overview widget","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"em"}]},{"text":"dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"After applying changes, List Type is now set to ","type":"text"},{"text":"MDX ","type":"text","marks":[{"type":"em"}]},{"text":"and the selected elements are listed in the MDX statement in the textbox ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change List Type back to ","type":"text"},{"text":"Subset ","type":"text","marks":[{"type":"em"}]},{"text":"and choose ","type":"text"},{"text":"Default ","type":"text","marks":[{"type":"em"}]},{"text":"from Subset drop-down list","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the popup ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 9 page 2-Close the popup.mp4","id":"2273b548-fa2e-4f66-8b52-9a7f0310917e","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"6. Rollup ","type":"text"}]},{"type":"paragraph","content":[{"text":"Rollup ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"functionality, allows users to quickly and easily aggregate data from selected members into a single, summarized record. The rollup feature can simplify data analysis and provide more comprehensive view of information. Aggregated data can be displayed in tables and charts. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In Subset Editor you will find dedicated ","type":"text"},{"text":"Rollup ","type":"text","marks":[{"type":"em"}]},{"text":"button or you can utilize the ","type":"text"},{"text":"Rollup ","type":"text","marks":[{"type":"em"}]},{"text":"option inside the context menu. ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"6eb71cf7-ab70-4f0c-a817-0d6821c9b4db"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"40356607-4e08-4128-84ac-16855757afc2"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the subset editor for Region dimension in Overview widget","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click","type":"text"},{"text":" Show All Elements (All E)","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select all leaf level elements ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Rollup ","type":"text","marks":[{"type":"em"}]},{"text":"button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"button ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"You will notice that new rollup was saved in the subset editor toolbar. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 10 page 2-editor toolbar.mp4","id":"37a86ca3-0236-4874-ad42-c3e606b6b664","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"button","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"New consolidated element will be visible in the table ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open subset editor again ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the x button to reset the Rollup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select different leaf level elements ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on any element to open up the context menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Rollup ","type":"text","marks":[{"type":"em"}]},{"text":"from the context menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the x button to reset the ","type":"text"},{"text":"Rollup ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Rollup ","type":"text","marks":[{"type":"em"}]},{"text":"will be no longer visible in the subset editor toolbar ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 11 page 2-editor toolbar.mp4","id":"b8909d06-f5a5-4317-b16f-ca014c3c04dc","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"7. Expand above ","type":"text"}]},{"type":"paragraph","content":[{"text":"Enabling this option reverses the order in which child elements are displayed under (or above) their parent consolidations. ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"bfbab223-cb07-41c9-932f-7a8f04c24423"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"ab8b8964-60b1-4080-b7fa-d991465c63a3"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Show All Elements (All E)","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Expand Above","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"button","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Collapse and expand Region dimension consolidations and you will notice that the order in which children elements are displayed changed. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 12 page 2-displayed changed.mp4","id":"c989fef4-0cc8-4d4d-a43c-e30d39b3812b","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Working with Settings Service ","type":"text"}]},{"type":"paragraph","content":[{"text":"Values stored in settings service can be easily retrieved and utilized in reports. For instance, you can use them to set dynamic titles and descriptions, pass them into MDX and more. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The values in the Settings Service are stored in a 3-part key, delimited by periods. This key includes information such as the instance name, dimension name, and hierarchy name, making it easy to access and work with these values. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Syntax example: UX_Demo.Product.Product ","type":"text","marks":[{"type":"strong"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. UX Placeholders ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"» Dynamic Titles ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this exercise, you'll be using the UX placeholder to set a dynamic title that changes based on the global filter value. ","type":"text"}]},{"type":"paragraph","content":[{"text":"To do this, you need to reference that value in the report's title using the UX placeholder. This way, every time the user changes the filter, the report title will update accordingly","type":"text"}]},{"type":"decisionList","attrs":{"localId":"926cc57f-240b-4e41-aaba-c0a8a4c4cabf"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"c5981a67-2c9e-4eb3-95db-dfeb9abd71e5"},"content":[{"text":"Follow the steps ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"Sales Planning","type":"text","marks":[{"type":"em"}]},{"text":" view (Exercises / Views) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable the ","type":"text"},{"text":"Edit Mode ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the page title ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change it to: ","type":"text"},{"text":"Sales Planning $<>","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the ","type":"text"},{"text":"Region ","type":"text","marks":[{"type":"em"}]},{"text":"global filter to ","type":"text"},{"text":"World ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that the title updated ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 13 page 2-title updated.mp4","id":"98302655-1351-48c4-9422-ddfe67961a32","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"With the use of the UX placeholder, you can also retrieve the alias of elements. This is done by using the syntax: $<>","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"» Attribute values ","type":"text"}]},{"type":"paragraph","content":[{"text":"It is also possible to retrieve specific attribute value from Settings Service and use in e.g view title. You must use the following syntax: ","type":"text"},{"text":"$<> ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"In this exercise you will retrieve values for Region dimension Country Code attribute. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the attribute to show correctly in the frontend option called","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"All Attributes ","type":"text","marks":[{"type":"em"}]},{"text":"needs to be enabled","type":"text"},{"text":". ","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"This is how we enable it: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Filterbar option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set ","type":"text"},{"text":"All Attributes","type":"text","marks":[{"type":"em"}]},{"text":" to Yes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse the settings panel","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Reload the page ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable the edit mode","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 14 page 2-edit mode.mp4","id":"16ecd7e2-4bca-490e-8c12-acb6b281a706","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"decisionList","attrs":{"localId":"f2817ace-0092-4d09-914a-3ec1112f3eb4"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"e4f089dc-a7f4-4631-8065-c9e322ff6a5e"},"content":[{"text":"Then follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the view title ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change it to: ","type":"text"},{"text":"Sales Planning $<> ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the ","type":"text"},{"text":"Region ","type":"text","marks":[{"type":"em"}]},{"text":"global filter to ","type":"text"},{"text":"Spain ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that the title says: ","type":"text"},{"text":"Sales Planning ES ","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 15 page 2-Sales Planning ES.mp4","id":"a761508c-2a0d-4386-aabf-4478d6f051d0","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Those variables can be used in every text field in the view definition: info tool-tips, page titles etc. as well as in MDX query.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2. Dynamic MDX ","type":"text"}]},{"type":"paragraph","content":[{"text":"UX placeholders can be part of MDX expressions that are used when configuring dimensions. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this example you will configure ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"em"}]},{"text":"dimension","type":"text"},{"text":" (Exercises / Views / Sales Planning view) ","type":"text","marks":[{"type":"em"}]},{"text":"to dynamically change the column content depending on the selected global filter. ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"f2afd22d-3a7b-422b-988e-b24818b280ed"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"6926d312-c0ff-4cad-b774-e9db85c036a9"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the cube icon to open up the cube settings popup","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the sub-view to ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"em"}]},{"text":"column dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel and select ","type":"text"},{"text":"Dimension Settings ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the ","type":"text"},{"text":"List Type","type":"text","marks":[{"type":"em"}]},{"text":" to ","type":"text"},{"text":"MDX ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the MDX text box input: ","type":"text"},{"text":"{[Version].[Version].[$<>]} ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the Cube Settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"em"}]},{"text":"global filter to ","type":"text"},{"text":"Budget ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that the data as well as column header updated","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 16 page 2-Save the changes.mp4","id":"cec7a88c-7fad-45a7-9c55-08706ff3420b","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"3. Dynamic Formatting ","type":"text"}]},{"type":"paragraph","content":[{"text":"Another way to utilize the UX placeholders is to make the formatting of our table more dynamic. Instead of using the column name for formatting, we can use the UX placeholder, which will apply the formatting based on the value of the global filter. ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"01f04778-124a-4186-ac2a-84376232e3e1"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"99287df1-c261-4ec0-9b03-5580847b0595"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the cube icon to open up the cube settings popup","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click + icon visible the Global Filters section ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the popup: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the dropdown list select ","type":"text"},{"text":"Period ","type":"text","marks":[{"type":"em"}]},{"text":"dimension","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Add Dimension","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the ","type":"text"},{"text":"Attribute ","type":"text","marks":[{"type":"em"}]},{"text":"(for newly added Period dimension) to ","type":"text"},{"text":"Short Description","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the cube settings popup","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 17 page 2-cube settings popup.mp4","id":"3af0e98e-1d97-42e3-b332-b80f9d6dc53d","collection":"contentId-2509045973","type":"file","height":910}}]},{"type":"decisionList","attrs":{"localId":"097f9d98-e64e-4319-b128-27ff2b6b83c5"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"40e413cf-7629-4c69-8e86-682c32ffa2af"},"content":[{"text":"Follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced option panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expand ","type":"text"},{"text":"Table Config","type":"text","marks":[{"type":"em"}]},{"text":" section by clicking on the + icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Column Format ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"+ Column Format ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add ","type":"text"},{"text":"Feb ","type":"text","marks":[{"type":"em"}]},{"text":"column by selecting it from the dropdown list and clicking + ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"id":"7bb7f486-947a-4283-bb08-4f0bd0d4b5f9","collection":"contentId-2509045973","type":"file","height":910}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the pencil icon in","type":"text"},{"text":" className ","type":"text","marks":[{"type":"em"}]},{"text":"textbox and select any class ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the ","type":"text"},{"text":"CODE ","type":"text","marks":[{"type":"em"}]},{"text":"tab ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Replace the ","type":"text"},{"text":"Feb ","type":"text","marks":[{"type":"em"}]},{"text":"column name with ","type":"text"},{"text":"$<> ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Change the ","type":"text","marks":[{"type":"strong"}]},{"text":"Period ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"global filter and notice that formatting is based on currently selected value (only ","type":"text","marks":[{"type":"strong"}]},{"text":"Year ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"column will have different formatting applied)","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 19 page 2-formatting applied).mp4","id":"53fa9230-b4af-428e-81e0-c6be5c7735a4","collection":"contentId-2509045973","type":"file","height":910}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"4. UX placeholders used in hierarchy context ","type":"text"}]},{"type":"paragraph","content":[{"text":"This functionality allows users to dynamically define a dimension hierarchy using a placeholder. After clicking ","type":"text"},{"text":"Select ","type":"text","marks":[{"type":"em"}]},{"text":"button the ","type":"text"},{"text":"Hierarchy ","type":"text","marks":[{"type":"em"}]},{"text":"dropdown list will be changed to text box to enable placeholder input. ","type":"text"}]},{"type":"decisionList","attrs":{"localId":"a7e719d1-7a36-42d4-ac1e-47e2b3e1f464"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"7d8546c5-6005-48c1-8065-0c79339f06e9"},"content":[{"text":"Create new view","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Add public...","type":"text","marks":[{"type":"em"}]},{"text":" option inside ","type":"text"},{"text":"Exercises - Views ","type":"text","marks":[{"type":"em"}]},{"text":"folder ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Do the following configuration inside the popup: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add view title: ","type":"text"},{"text":"Dynamic hierarchy ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Cube Source by selecting ","type":"text"},{"text":"Retail ","type":"text","marks":[{"type":"em"}]},{"text":"from the dropdown list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Create","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Publish ","type":"text","marks":[{"type":"em"}]},{"text":"the view","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 20 page 2-Publish the view.mp4","id":"135ca982-c129-4746-82bc-90bbc7cae0cf","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"decisionList","attrs":{"localId":"077f7ccc-1fd1-4626-86c3-886a49ad531b"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"f86cffac-025f-4c1a-a985-6fe504b8d89b"},"content":[{"text":"Set up the view","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the cube icon to open cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Default ","type":"text","marks":[{"type":"em"}]},{"text":"view ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Drag and drop: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Period ","type":"text","marks":[{"type":"em"}]},{"text":"to Row Dimensions ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"to Column Dimensions ","type":"text"}]}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 21 page 2-Column Dimensions.mp4","id":"8e2356d1-c995-4355-8d59-6e7bb6b82b31","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"decisionList","attrs":{"localId":"ba8fdbad-111d-41cb-9918-e0bd77696952"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"948af663-62a0-437e-9b91-6acf04232807"},"content":[{"text":"Set up Product dimension to dynamically change based on the hierarchy selected","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Add Dimension ","type":"text","marks":[{"type":"em"}]},{"text":"(+ icon) button in Global Filters section ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose ","type":"text"},{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Add Dimension","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Add Dimension ","type":"text","marks":[{"type":"em"}]},{"text":"(+ icon) button again ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set ","type":"text"},{"text":"Control Objects","type":"text","marks":[{"type":"em"}]},{"text":" option to ","type":"text"},{"text":"Yes ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose ","type":"text"},{"text":"}Hierarchies_Product ","type":"text","marks":[{"type":"em"}]},{"text":"from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Add Dimension","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 22 page 2-Dimension button.mp4","id":"6a6e86e2-508b-4fff-a4df-1c7dae89caa8","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"}Hierarchies_Product","type":"text","marks":[{"type":"em"}]},{"text":" dimension ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Subset Editor ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click","type":"text"},{"text":" All E ","type":"text","marks":[{"type":"em"}]},{"text":"button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Product:Color","type":"text","marks":[{"type":"em"}]},{"text":" and ","type":"text"},{"text":"Product:Size","type":"text","marks":[{"type":"em"}]},{"text":" from the list of available elements ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Apply ","type":"text","marks":[{"type":"em"}]},{"text":"button","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Product global filter","type":"text","marks":[{"type":"underline"},{"type":"em"}]},{"text":" dimension ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel ","type":"text"},{"text":"Dimension Settings ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Select ","type":"text","marks":[{"type":"em"}]},{"text":"button visible above ","type":"text"},{"text":"Hierarchy ","type":"text","marks":[{"type":"em"}]},{"text":"dropdown list","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the editable text box input UX Placeholder: $<>","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the List Type to ","type":"text"},{"text":"MDX ","type":"text","marks":[{"type":"em"}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Product dimension added in columns","type":"text","marks":[{"type":"underline"},{"type":"em"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add the same placeholder in the ","type":"text"},{"text":"Hierarchy ","type":"text","marks":[{"type":"em"}]},{"text":"text box ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the List Type to ","type":"text"},{"text":"MDX ","type":"text","marks":[{"type":"em"}]}]}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 23 page 2-Type to MDX.mp4","id":"95a8c07b-03eb-4526-9121-0d70f1b5807a","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change }Hierarchies_Product filter to ","type":"text"},{"text":"Product:Size ","type":"text","marks":[{"type":"em"}]},{"text":"and back to ","type":"text"},{"text":"Product:Color ","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"paragraph","content":[{"text":"Notice how Product dimension hierarchy dynamically updated in global filter as well as in columns. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 24 page 2-Save the changes.mp4","id":"0f8aaf8e-e49b-4843-b739-e3a6e76f9600","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"This configuration will work for global filters as well as for dimensions selected in rows or columns.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"5. Nested UX placeholders ","type":"text"}]},{"type":"paragraph","content":[{"text":"Use the view configured in the previous exercise to practice adding nested UX placeholders. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this example the selection will be even more dynamic, both filters are configurated the same way as in previous case, but the MDX changes were made for the ","type":"text"},{"text":"Product dimension added in columns.","type":"text","marks":[{"type":"underline"},{"type":"em"}]}]},{"type":"decisionList","attrs":{"localId":"525851f1-8288-4882-a449-270bd2314d81"},"content":[{"type":"decisionItem","attrs":{"state":"DECIDED","localId":"050c76c3-b0dd-4f62-bb8c-8b2d8883dae9"},"content":[{"text":"Update the configuration and follow the steps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the cube icon to open cube settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"dimension added in columns ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open advanced options panel and select ","type":"text"},{"text":"Dimension Settings","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Select ","type":"text","marks":[{"type":"em"}]},{"text":"button visible above ","type":"text"},{"text":"Hierarchy ","type":"text","marks":[{"type":"em"}]},{"text":"dropdown list","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the editable text box input UX Placeholder: $<>","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the MDX query to: ","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"{[Product].[$<>].[$<>>>]}","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select element from ","type":"text"},{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"global filter and notice how the column element dynamically updated ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change ","type":"text"},{"text":"}Hierarchies_Product","type":"text","marks":[{"type":"em"}]},{"text":" filter to ","type":"text"},{"text":"Product:Size","type":"text","marks":[{"type":"em"}]},{"text":" and select different element from ","type":"text"},{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"global filter ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Above example shows that by nesting two UX placeholder statements within each other users can not only define dynamic element selection based on filters, but also dimension hierarchy. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 25 page 2-dimension hierarchy.mp4","id":"640f3c39-f403-4f2c-9be3-4864a806b27b","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"MDX details: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"{[Product]. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"product dimension ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"[$<>]. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"dynamic hierarchy based on the global filter selection ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"[$<>>>]}","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"nested UX placeholder enabling to selection from Product dimension even when its hierarchy is changing dynamically","type":"text"}]}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Working with Attributes ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Cell Types ","type":"text"}]},{"type":"paragraph","content":[{"text":"Apliqo supports few predefined cell types that can help you create the reports you need, we will take a look at ","type":"text"},{"text":"Date picker & Checkbox. ","type":"text","marks":[{"type":"strong"}]},{"text":"Both of them are defined by ","type":"text"},{"text":"CellType ","type":"text","marks":[{"type":"em"}]},{"text":"attribute. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":385,"id":"ff38467d-8c98-4569-9dc6-328b220fa66b","collection":"contentId-2509045973","type":"file","height":280},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"Navigate to UX Samples - Cell Types - Date Picket options ","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's see what will happen when we change the Cell Type: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Set Cell Type popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Checkbox CellType and notice that the box is checked ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Clear the Checkbox CellType by clicking backspace button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cell type changed and the checkbox is no longer visible ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Input checkbox value into the cell to change the type again ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 26 page 2-type again.mp4","id":"f64fa4ee-1394-4a48-9570-343a873a9d7b","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the date CellType and notice that the calendar opens ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Clear the \"date\" value ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The calendar is no longer available ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Input date value into the cell to change the type again ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 27 page 2-the type again.mp4","id":"c81c7f90-aa51-4b75-a3a4-ffb804280515","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2. Table format based on attribute ","type":"text"}]},{"type":"paragraph","content":[{"text":"Navigate to UX Samples - Attributes -Format - driven by Attribute ","type":"text"}]},{"type":"paragraph","content":[{"text":"In Simple Condition widget you can edit the value of the Region UX_Class attribute that is is used to drive the format in the Style grid. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's try it out: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"change the value for USA cell to bg-orange-600 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"you will notice that the formatting in style widget changed ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"chrome_GJrxgOvOY9.mp4","id":"d716a8a4-88de-403f-bc04-471adcc107f5","collection":"contentId-2509045973","type":"file","height":910},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"Now let's take a look at the advanced options to see how this was achieved: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Style widget header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the CODE tab ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the table section you will notice that instead of class the attribute was used to drive the formatting ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"chrome_QKZ6h4Qv04.mp4","id":"dd0cb880-8ab0-4307-9e14-935d99d6eb9e","collection":"contentId-2509045973","type":"file","height":910},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Replace UX_Class with: ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":" $<> ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"change the }ElementAttributes_Region global filter to","type":"text"},{"text":" Class2","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"paragraph","content":[{"text":"You will notice that the cell color for the USA and Brazil elements was updated. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"chrome_gNc1AeVyPC.mp4","id":"2d60f47e-0935-438c-aee2-b5de5dd1e7fd","collection":"contentId-2509045973","type":"file","height":910}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"3. Read only based on attribute ","type":"text"}]},{"type":"paragraph","content":[{"text":"Read-only access can be applied to the whole table, specific rows, columns or be based on attribute value. In this exercise you will use UX Placeholder to see how the read access can change based on the selected filter. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise navigate to UX Samples - Attributes - ReadOnly and Popup display based on dimension attribute. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Take a look at the","type":"text"},{"text":" Read only option based on Region dimension attribute ","type":"text","marks":[{"type":"em"}]},{"text":"widget, right now the leaf level elements are editable, which is indicated by the grey formatting. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Region global filter to Brazil ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Formatting of the cells will be changed to read only ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 31 page 2-to read only.mp4","id":"1dacc55a-cf76-48e8-a642-4b27a1e69948","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Follow the steps below to practice the configuration: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the subset editor for Region global filter ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the attributes list select ReadOnly (this atribute is used to dynamically drive read access of the table. It's configured with true/false values) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the pencil icon to edit the attributes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the value of ReadOnly attribute for USA element to true ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Apply the changes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Region global filter to USA and you will notice that cells are no longer editable ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 32 page 2-no longer editable.mp4","id":"aebf33c6-af30-4b2b-879e-b5721b611866","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"In this part you will check the advanced options that allowed for readOnly access to change dynamically: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel and select CODE tab ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the ","type":"text"},{"text":"Read only option based on Region dimension attribute","type":"text","marks":[{"type":"em"}]},{"text":" widget header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Under the table section you will see \"readOnly\" option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In this example true/false value was replaced with the placeholder referencing in this case Region global filter dimension and ReadOnly attribute: ","type":"text"}]}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"\"$<>\" ","type":"text"}]},{"type":"paragraph","content":[{"text":"For this to work correctly the All Attributes option under Filterbar section needs to be turned on. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 33 page 2-be turned on.mp4","id":"961d8d5b-1cb9-4fce-aa32-fca4af320d64","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"4. Show table popup based on attribute ","type":"text"}]},{"type":"paragraph","content":[{"text":"By default, popup icon will appear for all elements in the table. However, if you want to limit the display of the icon to only certain elements based on their attribute values, you can do so by assigning a value of 1 to those elements. This exercise will show you how to set up and use this feature effectively. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise navigate to UX Samples - Attributes - ReadOnly and Popup display based on dimension attribute. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Take a look at the ","type":"text"},{"text":"Popup display based on Region dimension attribute ","type":"text","marks":[{"type":"em"}]},{"text":"widget, popup icon is limited to just few rows. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps below to practice the configuration: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the subset editor for Region global filter ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the attributes list select ShowTablePopUp (you can use whatever name you prefer for your attribute) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the pencil icon to edit the attributes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the value for America, Europe & Asia to 1 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Apply the changes ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"And all done, now the popup icon will be displayed for the selected elements (all with the value 1) from the dimension. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 34 page 2-the dimension.mp4","id":"cd35692a-0021-41f5-8e80-68388e6a358a","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Second part of the configuration was done using table advanced options: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the ","type":"text"},{"text":"Popup display based on Region dimension attribute ","type":"text","marks":[{"type":"em"}]},{"text":"widget header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select","type":"text"},{"text":" Table Config ","type":"text","marks":[{"type":"em"}]},{"text":"section ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Popup Attribute Enabled ","type":"text","marks":[{"type":"em"}]},{"text":"option needs to be set to ","type":"text"},{"text":"Yes ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change it to ","type":"text"},{"text":"No","type":"text","marks":[{"type":"em"}]},{"text":" and notice that now the popup icon will be displayed for all Region elements in the table ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change it back to ","type":"text"},{"text":"Yes ","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"paragraph","content":[{"text":"Also correct ","type":"text"},{"text":"Display Popup Attribute","type":"text","marks":[{"type":"em"}]},{"text":" must be selected from the list to ensure correct configuration. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 35 page 2-correct configuration.mp4","id":"89cf957d-0bf9-41ee-a495-a111bf5792cc","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Table Advanced Options ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Zero Suppression ","type":"text"}]},{"type":"paragraph","content":[{"text":"In case you do not want your table to display rows/ columns containing only null data, you can achieve this by changing the 'Zero Supression' settings. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Navigate to Views - Sales Planning ","type":"text"}]},{"type":"paragraph","content":[{"text":"Before following below steps notice that rows displaying only 0s were hidden. Now you will check what happens if you change this option: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click view Cube Settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Zero Suppression drop-down list and un-check Rows and Columns option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open advanced options panel and select SubView Settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Zero Suppression Button drop-down list and chose Rows and Columns ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the Cube Settings popup ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"If you look at the table now you will rows contain 0 values. Select rows from the new Zero Suppression button and they will disappear again. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 36 page 2-disappear again.mp4","id":"1f18d202-7b50-48b0-b987-9840de03e071","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"When the Zero Suppression button is enabled, there is no need to go back to the cube settings to change zero suppression selection, it can be done directly from the view level.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2. Subset Selection ","type":"text"}]},{"type":"paragraph","content":[{"text":"To provide a more dynamic analysis of the data, another very useful feature is available in the cube settings - Subset Selection. Enabling it allows you to change the subsets of the dimension from the list available at the view level. Additionally, we decide which subsets are included in the selection. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Do the following configuration: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open view Cube Settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Product dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel and select Dimension Settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable Subset Selection ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose Accessories, Bikes and Clothing in Multi Subset Selection list ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Close the pop-up and check the subset selection availability and save the changes. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 37 page 2-save the changes.mp4","id":"8f6649c9-89fa-4f2d-b435-9f2028ada7f6","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"3. Context menu options ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" User defined consolidations: Rollup ","type":"text"}]},{"type":"paragraph","content":[{"text":"Two new options, ","type":"text"},{"text":"Rollup ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"and ","type":"text"},{"text":"Custom Rollup","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":", have been added to the context menu for grid widgets and views. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Rollup:","type":"text","marks":[{"type":"strong"}]},{"text":" creates a new element that summarizes the selected members by displaying their sum. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Users also have the ability to create a ","type":"text"},{"text":"Custom Rollup ","type":"text","marks":[{"type":"strong"}]},{"text":"which","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"requires an additional dialog in order to select the mathematical function to apply to the rollup. ","type":"text"}]},{"type":"paragraph","content":[{"text":"You can specify both ","type":"text"},{"text":"Rollup Name","type":"text","marks":[{"type":"em"}]},{"text":" and ","type":"text"},{"text":"Rollup Function:","type":"text","marks":[{"type":"em"}]},{"text":" ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"AGGREGATE/SUM: ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"display the total for the selected members","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"},{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"AVG","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":": display the average value of the selected members ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"COUNT","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":": display the number of the selected members ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"MIN","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":": display the minimum value of the selected members ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"MAX","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":": display the maximum value of the selected members ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"STDDEV","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":": displays sample standard deviation of the selected members ","type":"text"},{"text":"Follow the steps below to practice it: ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select few elements from Product dimension (e.g. leaf level elements from Mountain Bikes) • Right click on one of the elements to open up a context menu • Select Rollup option ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"New consolidated element Product Sum will appear in the table. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 38 page 2-in the table.mp4","id":"ed0bb71e-45d0-4428-96f6-9b0aba6efdae","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"You can edit the Rollup at any time: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"right click on the Product Sum element ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"select Edit Rollup option from the context menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"in the popup do the following configuration ","type":"text"}]}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"◦ Change the Rollup Name to: Product AVG ","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"◦ Change the function to AVG ","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"◦ Apply the changes ","type":"text"}]},{"type":"paragraph","content":[{"text":"Now the Product AVG element is showing the average value for the selected elements. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 39 page 2-selected elements.mp4","id":"44a43208-f2b7-4d58-b315-001b30029deb","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"What is more you can also Save the changes made or Reset them to get back to the original view configuration: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the Product AVG element ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Save option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the view & reload the page ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Product AVG will still be available in the view configuration ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 40 page 2-view configuration.mp4","id":"9f501cb2-74d3-42d8-afb1-30bab1344620","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable the edit ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the Product AVG element ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Reset option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Product AVG will no longer be available in the view configuration ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 41 page 2-Save the changes.mp4","id":"a3e4c0a0-97f1-4f21-a93c-616d6bc7fbf1","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Subset Editor Shortcuts ","type":"text"}]},{"type":"paragraph","content":[{"text":"These shortcuts allow you to change selected elements or attributes on the fly, making it easy to manipulate data quickly and efficiently. There's also an option to reset or save changes. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the Helmets element ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Selection list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Keep + children ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"You will notice that the table updated the selection accordingly ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the Helmets element ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Attributes list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Spanish Description ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Product dimension will now display updated attribute ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Reset from the context menu to return to the original configuration ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 42 page 2-original configuration.mp4","id":"b919463a-e20a-4b56-9549-3ba3708d4c3c","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Inserting new column and row ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this exercise, we'll focus on enhancing reports by inserting new columns or rows. Adding custom calculations to your reports can provide valuable insights and context to your data, making it more informative and visually appealing. ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Adding column ","type":"text","marks":[{"type":"underline"}]}]},{"type":"paragraph","content":[{"text":"First we will add a column: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the ","type":"text"},{"text":"Dec ","type":"text","marks":[{"type":"em"}]},{"text":"column ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose ","type":"text"},{"text":"Insert column right","type":"text","marks":[{"type":"em"}]},{"text":" form the list ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Context menu will automatically close and the new column will appear in the table. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 43 page 2-in the table.mp4","id":"fed24c53-4eaf-4ffc-86f9-24a477355924","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Adding new rows works the same way. After right clicking on the row element, context menu appears and we will have the option to add row above or below selected element.","type":"text"}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Column title change","type":"text","marks":[{"type":"underline"}]}]},{"type":"paragraph","content":[{"text":"All the columns added to the table will appear with the default name: Inserted + number (depending on the amount of already added columns). ","type":"text"}]},{"type":"paragraph","content":[{"text":"It can be changed using context menu: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the inserted column header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Edit Column Header from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the new title in the popup: ","type":"text"},{"text":"New Column ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click Save ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that the column header updated ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 44 page 2-Save the changes.mp4","id":"2ae3fd53-66e4-4afc-b211-d4473d16e29f","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Formulas ","type":"text"}]},{"type":"paragraph","content":[{"text":"Adding new columns in views or grid widgets is often done to perform further calculations. The application allows us to use arithmetic operations or standard Excel formulas. ","type":"text"}]},{"type":"paragraph","content":[{"text":"We will use our new column to calculate the sum of the values for the first half of the year, so months of Jan through Jun. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Toggle Excel Headers","type":"text","marks":[{"type":"em"}]},{"text":" button for easier formulas input ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the firs row cell in ","type":"text"},{"text":"New Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Input the formula e.g. ","type":"text"},{"text":"=SUM(D1:J1)","type":"text","marks":[{"type":"strong"}]},{"text":" and click Enter ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 45 page 2-click Enter.mp4","id":"b6471597-9753-4044-a348-3dd468e32912","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Formula entered on the first row cell is automatically applied to all elements in rows. Now only the first row cell is editable.","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"You can change it: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"right clicking on the first cell in New Column ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"select","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Remove Auto Column Fill","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"from the context menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"select","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Auto Column Fill","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"from the context menu to populate rest of the cells again •","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 46 page 2-save the changes.mp4","id":"bb7d0eff-e2a1-49fe-9d73-c91a0fc74e1b","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"DBRW function","type":"text","marks":[{"type":"underline"}]}]},{"type":"paragraph","content":[{"text":"DBRW function which uses the same syntax as in Perspectives or PAfE is also supported. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this exercise we will use this function: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"=DBRW(\"UX_Demo\", \"Retail\", \"Actual\", \"2012\", \"$<>\", \"Local\", \"USA\", ","type":"text"}]},{"type":"paragraph","content":[{"text":"A1, \"Sales Amount\") ","type":"text"}]},{"type":"paragraph","content":[{"text":"Period","type":"text","marks":[{"type":"strong"}]},{"text":" dimension was replaced with: ","type":"text"},{"text":"'$<>'","type":"text","marks":[{"type":"strong"}]},{"text":" to allow the value to dynamically change together with the Global filter. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Product","type":"text","marks":[{"type":"strong"}]},{"text":" dimension was replaced with","type":"text"},{"text":" A1","type":"text","marks":[{"type":"strong"}]},{"text":", which refers to the row dimension ","type":"text"},{"text":"Follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Double click on the first row cell in ","type":"text"},{"text":"New Column ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Input the DBRW function and click Enter ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Period global filter to May ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that the data updated ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"As you can see, the data from the New Column displays the same data as the May column. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 47 page 2-May column.mp4","id":"f295a075-4721-4a15-8e11-e684ab6c34f7","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"COLHEAD - referencing column headers in custom formulas ","type":"text","marks":[{"type":"underline"}]}]},{"type":"paragraph","content":[{"text":"To fully benefit from the formulas new custom function =COLHEAD(1,0) was added to the app that allows to reference column header name. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"First parameter refers to column number (starting from 0 for column A) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Second parameter specifies the column header index and is needed only if nested column headers are used, in which case the user must specify the header row. The default value if omitted is 0. ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"In this exercise you will use a DBRW function, which will include =COLHEAD formula. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"First you will update New Column name and connect it with Period global filter with the use of settings service placeholder: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the New Column header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Edit Column Header","type":"text","marks":[{"type":"em"}]},{"text":" option","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"from the context menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the textbox input $<> ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Save","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"The column name will update to match the current Period global filter selection. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 48 page 2-global filter selection.mp4","id":"b4e0e95a-f9b9-4548-9490-b2127bdc89f4","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"In this part of the exercise you will add DBRW formula to the table. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"double click on the first cell in the Year column (so it will become editable)","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"input the following formula in the cell =DBRW(\"UX_Demo\",\"Retail\",\"Actual\",\"2012\", COLHEAD(15), \"Local\",\"USA\",A1, \"Sales Amount\") ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Now, thanks to the fact that you used a settings service placeholder in the column name and a new COLHEAD formula in the DBRW function, you can see how the data will dynamically update when we change the Period global filter. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Change the Period global filer by selecting Jan from the dropdown list. The column name header as well as the column data will update. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 49 page 2-data will update.mp4","id":"888e1847-7c24-4e12-9aaf-66feb69a686b","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"4. Cross Drill ","type":"text"}]},{"type":"paragraph","content":[{"text":"For better analytical possibilities, the application allows us to drill on each row, by any other dimension, which is part of the cube the view is based on. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise navigate to Exec Dashboard and follow those steps: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the USA element in the Overview widget ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that the context menu appeared and the ","type":"text"},{"text":"Drill down by...","type":"text","marks":[{"type":"em"}]},{"text":" option is available ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Chose Account from the list of available dimensions ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Drill appeared in the table and is marked with blue color. You can collapse and expend the consolidations. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"To close the drill, right click on one of its elements and choose ","type":"text"},{"text":"Close","type":"text","marks":[{"type":"strong"}]},{"text":" from the list. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 50 page 2-Close from the list.mp4","id":"78c82290-f2e9-41a4-8daf-cd7e0ad460bd","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"5. Spreading ","type":"text"}]},{"type":"paragraph","content":[{"text":"Spreading is used to distribute a value across a range of cells or all leaf elements in a consolidation. For the purpose of this exercise navigate to Reports / Views - Input on C-level Cells. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Once spreading is enabled two additional right-click menu options will appear: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Spreading (opens a separate dialog) ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Holds... ( leads to a sub menu) Follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Region global filter to USA ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right-click on February - Bottles and Cages • Select ","type":"text"},{"text":"Spreading ","type":"text","marks":[{"type":"em"}]},{"text":"option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the popup: ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Proportional ","type":"text","marks":[{"type":"em"}]},{"text":"Method ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Replace ","type":"text","marks":[{"type":"em"}]},{"text":"Data Action ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Input 1000 in the Value to be spread textbox ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click Apply ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"All leaf elements should now be equal 333. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 51 page 2-be equal 333.mp4","id":"8362640c-f27e-42c3-9813-a551cd40091c","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Spreading & Holds shortcut can be entered directly in the cell without using the right-click options or spreading dialog.","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Overview of available options ","type":"text"}]},{"type":"paragraph","content":[{"text":"Method: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The proportional spread method distributes a specified value among cells proportional to existing cell values. (P) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The equal spread method distributes a specified value equally across cells in a view (S) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The repeat method repeats a specified value across cells in a view.","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"(R) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Clear method clears values from cells in a view. (C) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The percent change method multiplies current cell values by a specified percentage. (P%) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The straight line data spreading method populates cube cells by linear interpolation between two specified endpoints. (SL) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The growth % method accepts an initial value and a growth percentage. (GR) ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Spreading advanced options ","type":"text"}]},{"type":"paragraph","content":[{"text":"When spreading is enabled for a view or widget then by default all spreading types are enabled. But with the use of advanced options you can control which types are allowed. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Spreading widget header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the + icon visible next to ","type":"text"},{"text":"Table Config","type":"text","marks":[{"type":"em"}]},{"text":" option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Spreading Items ","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"paragraph","content":[{"text":" All available spreading types will be visible in the right panel of the advanced options. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set ","type":"text"},{"text":"Proportional","type":"text","marks":[{"type":"em"}]},{"text":", ","type":"text"},{"text":"Equal ","type":"text","marks":[{"type":"em"}]},{"text":"and ","type":"text"},{"text":"Repeat ","type":"text","marks":[{"type":"em"}]},{"text":"to No ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse the Settings panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right-click on any cell in Spreading Widget ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Spreading ","type":"text","marks":[{"type":"em"}]},{"text":"from the menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open ","type":"text"},{"text":"Method ","type":"text","marks":[{"type":"em"}]},{"text":"dropdown list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disabled spreading types will not be visible ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 52 page 2-not be visible.mp4","id":"a3cb63dc-b07e-49ec-a4c6-e2f4f8b98b56","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Close the popup and Discard the changes. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Input on consolidations ","type":"text"}]},{"type":"paragraph","content":[{"text":"After enabling","type":"text"},{"text":" Input on Consolidations","type":"text","marks":[{"type":"em"}]},{"text":" in the advanced options by default non editable consolidated cells can be updated. It will work with spreading and holds shortcuts. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise we will use again Simple Planning template ","type":"text"},{"text":"Follow this steps to check out this functionality: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Jan cell for Accessories element and notice that the cell can't be edited ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open advanced options panel and expand Table Config option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Input on Consolidations and enable it ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Double click on the same cell again to check that now editable textbox will appear. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Save the changes. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 53 page 2-save the changes.mp4","id":"d4808c6d-45c8-424f-a15d-fcb1353bcd18","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"6. Number Format ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this section, we will learn how to override TM1 number format with the use of advanced options. For the purpose of this exercise we will use the Report / Views - Simple Planning Template. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Follow the steps below: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the settings for Table Config and select Column format ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the + icon next to Column Format ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select January from the dropdown list and click + icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the Number Format dropdown ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expand Zero, select - Minus and click Apply ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"All zero values in January column will be formatted using - sign instead of 0. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Discard the changes. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 54 page 2-discard the changes.mp4","id":"3d1d026d-0e83-4fc7-ab80-418b5b93c8c5","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Options available in Number Format dropdown: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Separator change: , or . ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Number of decimal places: from 0 to 4 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Option to apply: % Percentage, K Thousands, M Millions ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Negative values display : - or ( ) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Null values display: 0 or - • Add currency","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"7. Read only","type":"text"}]},{"type":"paragraph","content":[{"text":"Read only","type":"text","marks":[{"type":"em"}]},{"text":" option can be applied for the whole table if we don’t want enduser to update the data. It can be easily done by changing one advanced option. This functionality works independent of the TM1 security. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps below: ","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change Region global filter to USA ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Table Config option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change Read Only option to Yes ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Notice that the table changed formatting from gray to white and now leaf level elements can't be edited. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Discard the changes. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 55 page 2- discard the changes.mp4","id":"54fdd48d-583b-441a-b2d2-f5fdd622dc23","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Read only functionality can be also applied to specific rows or columns. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"We can select row / column and add it in the Column/Row format advanced option panel. Each added element additionally to formatting options have readOnly option. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change Region global filter to USA ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expand Table Config option and select Column Format ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the + icon next to Column Format ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add February column to the advanced options panel by clicking on the + icon visible next to the dropdown list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set readOnly option to Yes ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Again notice that the formatting for the February column changed and the cells are no longer editable. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 56 page 2-longer editable.mp4","id":"cbf7c85b-1d70-4fc8-af2d-c9622b5ec0bf","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"8. adHoc columns edit ","type":"text"}]},{"type":"paragraph","content":[{"text":"After enabling advanced adHoc columns option, users will have access to a new set of toolbar (or widget header) buttons to facilitate column editing without the need to manually change MDX query (especially asymmetrical selection for stacked dimensions). ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" ","type":"text"},{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Enabling adHoc columns ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise navigate to Reports / Views - AdHoc Edition - Asymmetric selection on columns with adHoc edit options. ","type":"text"}]},{"type":"paragraph","content":[{"text":"You will notice that on this page additional set of toolbar buttons is already visible. In the next steps you will disable and enable back adHoc column edit, follow the steps: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the + icon next to the ","type":"text"},{"text":"Table Config","type":"text","marks":[{"type":"em"}]},{"text":" option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Adhoc Columns ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set","type":"text"},{"text":" Compound Column Select","type":"text","marks":[{"type":"em"}]},{"text":" to No ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set","type":"text"},{"text":" Compound Column Select","type":"text","marks":[{"type":"em"}]},{"text":" to Yes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse the advanced options panel ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 57 page 2-advanced options panel.mp4","id":"e024842d-0128-4ed6-ac83-f282a37136a8","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" ","type":"text"},{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Overview of the available options ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add Column (+ icon):","type":"text","marks":[{"type":"strong"}]},{"text":" A new column will appear in the table with the default dimensions configured. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Duplicate columns:","type":"text","marks":[{"type":"strong"}]},{"text":" After selecting a column from the grid the button becomes active. After clicking it, duplicated column will appear in the table. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Pencil icon","type":"text","marks":[{"type":"strong"}]},{"text":" visible in the column headers allows users further customization of the stacked dimension without the need of changing MDX query. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Remove Column (trash can icon):","type":"text","marks":[{"type":"strong"}]},{"text":" Remove selected column from the table. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save Columns: ","type":"text","marks":[{"type":"strong"}]},{"text":"Save the changes ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" ","type":"text"},{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Configure Default Elements ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this example we are using ","type":"text"},{"text":"Year ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"strong"}]},{"text":"so the configuration needs will be done for those two element. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"First we have ","type":"text"},{"text":"dimension ","type":"text","marks":[{"type":"strong"}]},{"text":"and it's ","type":"text"},{"text":"hierarchy ","type":"text","marks":[{"type":"strong"}]},{"text":"which is used in our table. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Next is","type":"text"},{"text":" subset - ","type":"text","marks":[{"type":"strong"}]},{"text":"It will define what elements will be displayed in the dropdown list after clicking on the pencil icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Important part is also setting up column ","type":"text"},{"text":"default elements - ","type":"text","marks":[{"type":"strong"}]},{"text":"when adding new column default elements will be applied when click on the + icon ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Default options for new column were already added in this view but you for the purpose of this exercise you will change them:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Settings icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open CODE tab ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Under \"adHocColumns\" you will see \"columnDefaultElements\": ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change default element to 2014 for Year dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change default element to Budget for Version Dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click refresh button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 58 page 2-Save the changes.mp4","id":"424bffdf-30ec-4938-a8f0-4ba8e225457d","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" ","type":"text"},{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Exercise ","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"The changes will disappear after the full reload of the page, unless they were made in Edit Mode and the Save Columns option has been selected.","type":"text"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"+ ","type":"text","marks":[{"type":"strong"}]},{"text":"icon (new column 2014 Budget will appear in the table) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the pencil icon for ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"strong"}]},{"text":"dimension and change it to ","type":"text"},{"text":"Actual ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the pencil icon for ","type":"text"},{"text":"Year ","type":"text","marks":[{"type":"strong"}]},{"text":"dimension and change it to ","type":"text"},{"text":"2016 ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select new column and click on the ","type":"text"},{"text":"Duplicate ","type":"text","marks":[{"type":"em"}]},{"text":"button (new column 2014 Actual will appear in the table) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select newly duplicated column and click","type":"text"},{"text":" trash can","type":"text","marks":[{"type":"strong"}]},{"text":" icon (column will disappear from the table) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Save Columns","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changed ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 59 page 2-Save the changes.mp4","id":"c075edbd-db9e-4cb0-9b5d-bff53273a7c0","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"9. Undo the changes ","type":"text"}]},{"type":"paragraph","content":[{"text":"Undo","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"functionality allows users to view data entry changes made to values in a screen and to undo them if needed. A new button has been added to the toolbar on each page to allow user who made the data adjustments to undo changes. It will not be active until a change is detected. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise navigate to Simple planning template and follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Region global filter to USA ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the value for 483 - Bike Rack Standard element in January column to 5000 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Undo","type":"text","marks":[{"type":"em"}]},{"text":" button will be now active, click it ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":" New popup will appear where you can review the changes. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 60 page 2-review the changes.mp4","id":"3d060974-db0d-4ecd-b657-94cbe735d9a7","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"To undo the changes follow the steps below: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Check the box for the change you want to undo ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"UNDO button will become active, click it ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"The value in the table will be reverted to the original one. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 61 page 2-the original one.mp4","id":"f377af90-660f-42ac-bfb3-483b6d1f198a","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"When many changes are made at once (e.g. via a copy/paste action), these are stored in the change log in a summarized form: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the value for 483 - Bike Rack Standard element in January column to 5000 then drag and drop the value for the rest of the columns ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Undo","type":"text","marks":[{"type":"em"}]},{"text":" button will be now active, click it ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click","type":"text"},{"text":" Show details ","type":"text","marks":[{"type":"em"}]},{"text":"to review the changes for the batch ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Cancel ","type":"text","marks":[{"type":"em"}]},{"text":"to revert to previous view ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Check the box for the batch change ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"UNDO button will become active, click it ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"The values in the table will be reverted to the original one. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 62 page 2-the original one.mp4","id":"309df662-2231-4249-b1e6-241fc81571e8","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Charts configuration and edition ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Waterfall Chart ","type":"text"}]},{"type":"paragraph","content":[{"text":"In this section we will check out some of the advance adoptions specific for Waterfall chart. For the purpose of this exercise navigate to Latest Releases - UX Version 2020.08 - Waterfall Chart improvements ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Drill Down ","type":"text"}]},{"type":"paragraph","content":[{"text":"If the chart contains consolidated elements, you can drill down to display its children elements. • Click the Net Sales element ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Notice that the elements displayed in the waterfall chart were updated and now the children elements of Net Sales are being displayed ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the Gross Sales element and make sure that the chart once again changed its contents ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the House icon to navigate back to the original state ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 63 page 2-original state.mp4","id":"dfa2604f-238a-4372-891d-7060b3897560","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Name of the elements that can be drilled are marked in bold. Use breadcrumbs to navigate back to previous step on the drill path.","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Y-axis scaling ","type":"text"}]},{"type":"paragraph","content":[{"text":"Turning this option on will change the minimum value for the y-axis. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Department global filter to Executive General and Administrations ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the settings wrench icon an then on the Waterfall widget header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expand ","type":"text"},{"text":"Chart Options","type":"text","marks":[{"type":"em"}]},{"text":" and select ","type":"text"},{"text":"Waterfall Chart ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set ","type":"text"},{"text":"Y Axis Min Auto","type":"text","marks":[{"type":"em"}]},{"text":" to ","type":"text"},{"text":"Yes ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse the advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that now the differences between the values are more distinct & discard the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 64 page 2-discard the changes.mp4","id":"41bde622-cf56-452e-be38-3019cb08d08a","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Add commentary ","type":"text"}]},{"type":"paragraph","content":[{"text":"The Waterfall chart includes an enhancement that allows comments added to the table to be displayed directly in the chart. By default this option is not enabled, but you can easily change it using advanced options: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the settings wrench icon and then on the Waterfall widget header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expand ","type":"text"},{"text":"Chart Options","type":"text","marks":[{"type":"em"}]},{"text":" and select ","type":"text"},{"text":"Waterfall Chart ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set ","type":"text"},{"text":"Show Cell Commentary","type":"text","marks":[{"type":"em"}]},{"text":" to ","type":"text"},{"text":"Yes","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse the advanced options panel ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"In our example this option is already turned on. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 65 page 2-turned on.mp4","id":"113991ea-b70e-41d5-a340-7bc3fb00eb73","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Right click on the Operating Expenses cell in Actual column ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose Comments from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the text box write: ","type":"text"},{"text":"This is test commentary","type":"text","marks":[{"type":"em"}]},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Post ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that the cell is marked with red triangle that indicates that the comments was added ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Refresh","type":"text","marks":[{"type":"em"}]},{"text":" button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure that Waterfall chart is displaying the added comment for Operating Expenses element ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 66 page 2-Expenses element.mp4","id":"03a0f70f-1b91-467f-820b-7ccaf9974790","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"As the waterfall chart dynamically calculates the variance between 2 series, \"Comment Row: 1\" means that the chart will display comments for 1st series.","type":"text"}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"KPI widget types and configuration ","type":"text"}]},{"type":"paragraph","content":[{"text":"There are three types of KPI Widgets that can be added to a page to provide high level information that is key to a report:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"KPI ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"KPI Simple ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"KPI Trend ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"In this exercise we will add and correctly configure KPI trend widget. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to Exec Dashboard ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the plus icon and select Widget from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the popup:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the title to 'KPI'","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the cube source to 'General Ledger' ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click Create button ","type":"text"}]}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 67 page 2-Click Create button.mp4","id":"31fc732c-e819-41fc-a99e-22ebcad8757c","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Next, we are going to set up what information to retrieve for the KPI widget: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"change the widget type to 'KPI Trend' ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"open Cube Settings for the KPI widget ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"move Region dimension to rows ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change List Type to Subset ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"move Version dimension to rows ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change List Type to Element Comparison ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set Value to Actual and Value MAX to Budget ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"move Period dimension to columns ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the subset to Default ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the Attribute to Short Description ","type":"text"}]}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 68 page 2-Short Description.mp4","id":"250e503b-cad6-4bf8-bfca-f8907e31d4b4","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Adjust the widget size using the flexible layout ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Now the widget correctly displays a comparison of Actual and Budget for the countries we have selected. The period that has been defined is reflected in the graph at the bottom. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Save the changes. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 69 page 2-Save the changes.mp4","id":"51f7c20c-7bde-4be8-90b6-15e7adc01a95","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Advanced TI integration ","type":"text"}]},{"type":"paragraph","content":[{"text":"As an example for the advanced TI integration module, we will use the \"}bedrock.cube.data.export\" TI process. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Create a new Dashboard, called TI integration and publish it. Change the widget type from Grid to TI Process. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Basic TI setup ","type":"text"}]},{"type":"paragraph","content":[{"text":"Click on the settings icon and then select Process Config option: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set ","type":"text"},{"text":"Embed in Page","type":"text","marks":[{"type":"em"}]},{"text":" to Yes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select UX_Samples from the ","type":"text"},{"text":"Instance","type":"text","marks":[{"type":"em"}]},{"text":" drop-down list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select }bedrock.cube.data.export from the ","type":"text"},{"text":"Process Name ","type":"text","marks":[{"type":"em"}]},{"text":"drop-down list ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"This configuration will already show all the parameters of the process in the webform. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2. Advanced TI settings ","type":"text"}]},{"type":"paragraph","content":[{"text":"To make the results even friendlier to the users we can add additional code for the parameters. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Inside the \"parameters\" tag we can add additional config options, in order to set default values and hide specific parameters. Additionally, we can assign check boxes and subsets. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Here is the configuration we can use to make the process easier to us. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Below you can also find, in the attached file, the complete TI setup. ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"\"parameters\": {\n \"pLogoutput\": {\n \"hidden\": true,\n \"value\": 0\n },\n \"pCube\": {\n \"label\": \"Cube Name\",\n \"type\": \"subnm\",\n \"instance\": \"UX_Samples\",\n \"dimension\": \"}Cubes\",\n \"tm1Mdx\": \"{ [}Cubes].[}Cubes].Members }\",\n \"tm1Attribute\": \"\"\n },\n \"pView\": {\n \"hidden\": true\n },\n \"pFilter\": {\n \"hidden\": true\n },\n \"pFilterParallel\": {\n \"hidden\": true\n },\n \"pParallelThreads\": {\n \"hidden\": true,\n \"value\": 0\n },\n \"pDimDelim\": {\n \"label\": \"Dimension Delimiter\",\n \"disabled\": true,\n \"value\": \"&\"\n },\n \"pEleStartDelim\": {\n \"label\": \"Element Start Delimiter\",\n \"disabled\": true,\n \"value\": \":\"\n },\n \"pEleDelim\": {\n \"label\": \"Element Delimiter\",\n \"disabled\": true,\n \"value\": \"+\"\n },\n \"pSuppressZero\": {\n \"label\": \"Suppress Zero\",\n \"type\": \"checkbox\",\n \"trueValue\": 1,\n \"falseValue\": 0\n },\n \"pSuppressConsol\": {\n \"label\": \"Suppress consolidation\",\n \"type\": \"checkbox\",\n \"trueValue\": 1,\n \"falseValue\": 0\n },\n \"pSuppressRules\": {\n \"label\": \"Suppress rules\",\n \"type\": \"checkbox\",\n \"trueValue\": 1,\n \"falseValue\": 0\n },\n \"pZeroSource\": {\n \"label\": \"Clear Source Data\",\n \"type\": \"checkbox\",\n \"trueValue\": 1,\n \"falseValue\": 0\n },\n \"pCubeLogging\": {\n \"label\": \"Cube Logging\",\n \"type\": \"checkbox\",\n \"trueValue\": 1,\n \"falseValue\": 0\n },\n \"pTemp\": {\n \"label\": \"Use Temp Views\",\n \"type\": \"checkbox\",\n \"trueValue\": 1,\n \"falseValue\": 0\n },\n \"pFilePath\": {\n \"label\": \"File Path\",\n \"disabled\": true,\n \"value\": \"C:\\\\\"\n },\n \"pFileName\": {\n \"label\": \"File Name\",\n \"type\": \"input\"\n },\n \"pDelim\": {\n \"label\": \"File delimiter\",\n \"disabled\": true,\n \"value\": \",\"\n },\n \"pQuote\": {\n \"label\": \"File quote\",\n \"disabled\": true,\n \"value\": \"\\\"\"\n },\n \"pTitleRecord\": {\n \"label\": \"Title Records\",\n \"disabled\": true,\n \"value\": \"1\"\n },\n \"pSandbox\": {\n \"hidden\": true\n }\n },","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" » TI Process configuration using new Advanced Options GUI ","type":"text"}]},{"type":"paragraph","content":[{"text":"Parameters configuration is available in the dedicated tab: Process Parameters. ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":" Hide specific parameters ","type":"text","marks":[{"type":"underline"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 70 page 2-specific parameters.mp4","id":"b10e3652-5f87-4339-bad7-8d3284adb98a","collection":"contentId-2509045973","type":"file","height":936}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Add labels ","type":"text","marks":[{"type":"underline"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 71 page 2 - add labels.mp4","id":"fded32fa-e494-4518-bbf9-657f3dea30af","collection":"contentId-2509045973","type":"file","height":936}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Disable parameters","type":"text","marks":[{"type":"underline"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 72 page 2-Disable parameters.mp4","id":"96de80b4-6ea4-405d-9baa-6280bcaa97be","collection":"contentId-2509045973","type":"file","height":936}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Add default value ","type":"text","marks":[{"type":"underline"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 73 page 2-add default value.mp4","id":"5a828003-fa99-4949-b81b-2b834483448e","collection":"contentId-2509045973","type":"file","height":936}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Configure subnm selection ","type":"text","marks":[{"type":"underline"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 74 page 2-subnm selection.mp4","id":"599920c3-d26c-425d-96ea-d746bed6d105","collection":"contentId-2509045973","type":"file","height":936}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Change the parameter type to checkbox","type":"text","marks":[{"type":"underline"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 75 page 2-type to checkbox.mp4","id":"50eb46e9-f1d1-45fe-bd54-e0de22ed2012","collection":"contentId-2509045973","type":"file","height":936}}]},{"type":"paragraph","content":[{"text":"Final result should look like this: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":491,"id":"a1515105-2c3e-404a-9bfc-21d8bef7d100","collection":"contentId-2509045973","type":"file","height":384},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"3. Track process status in notification drawer ","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Since ","type":"text"},{"text":"UX Version 2023.10 ","type":"text","marks":[{"type":"strong"}]},{"text":"Notification drawer has been disabled by default (bell icon not visible in the app), to enable it please add the below option to the default.constants.js file and set it to true. ","type":"text"}]},{"type":"paragraph","content":[{"text":"'NOTIFICATION_DRAWER': true","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"File is located in ApliqoServer\\webapps\\Apliqo_Demo\\apq-c3-custom\\js folder. ","type":"text"}]}]},{"type":"paragraph","content":[{"text":"With the help of the ","type":"text"},{"text":"processes drawer ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"in the ","type":"text"},{"text":"notifications panel","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":", users can monitor running processes and their status changes. ","type":"text"}]},{"type":"paragraph","content":[{"text":"To benefit from this functionality, additional advanced option Enable Drawer was added for three TI Process Status Notifications: ","type":"text"},{"text":"Running, Success, Failed.","type":"text","marks":[{"type":"underline"}]}]},{"type":"paragraph","content":[{"text":"Navigate to Latest Releases - UX Version 2022.06 - Commentaries and Notification Follow the steps below to see how to enable it: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable the edit mode ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the settings icon and then on the ","type":"text"},{"text":"Add Product","type":"text","marks":[{"type":"strong"}]},{"text":" widget header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the + icon visible next to the ","type":"text"},{"text":"Process config ","type":"text","marks":[{"type":"strong"}]},{"text":"option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the + icon visible next to the ","type":"text"},{"text":"Status Notifications","type":"text","marks":[{"type":"strong"}]},{"text":" option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Success ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Notice that the ","type":"text"},{"text":"Drawer Enabled","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" option is set to ","type":"text"},{"text":"Yes ","type":"text","marks":[{"type":"strong"}]},{"text":"-> this is the option enabling users to keep track of process status changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 76 page 2-status changes.mp4","id":"66064da4-adbe-4ae1-a832-379bf582fa71","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Now we will see how the status changes will be shown in the notifications drawer: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"Add Product","type":"text","marks":[{"type":"em"}]},{"text":" widget input \"My New Product\" in the ","type":"text"},{"text":"Product ","type":"text","marks":[{"type":"em"}]},{"text":"textbox ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Run ","type":"text","marks":[{"type":"em"}]},{"text":"button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the process was successful, new notification will appear next to the bell icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expand the Process section ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the 3 dots icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select ","type":"text"},{"text":"Process Info","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" option to review the paraments","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 77 page 2-the paraments.mp4","id":"6cfccd0e-bc39-44e4-bbe2-8bbfff43141f","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"4. Create TI Process button from Action menu ","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Add menu","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" (located in the toolbar) now contains a new option: ","type":"text"},{"text":"TI button","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Choosing this option will open up a create dialog for the TI process button. User can specify: title, instance, process and location of the process button (by default it will be located in toolbar, but by enabling Widget PopUp it can be placed in a selected widgets' header instead) ","type":"text"},{"text":"Follow the steps below to try it out: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the + icon visible in the page toolbar • Select TI Button from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the popup: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Input title e.g. My New Process ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Pick one Process form the dropdown list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click Create ","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"New Process button will appear in the toolbar. Further configuration can be done with the advanced options GUI as explained in the previous exercises. Save the changes. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 78 page 2-save the changes.mp4","id":"6a703f53-9ecd-4c23-9405-ed93540ce1e0","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"5. Run on click ","type":"text"}]},{"type":"paragraph","content":[{"text":"New advanced option","type":"text"},{"text":" Run On-Click ","type":"text","marks":[{"type":"em"}]},{"text":"has been added to the Process Configuration to enable users to run the process with predefined parameter values without the need to open the popup dialog. After setting this option to true, the process will start with the button click and run in the background. For this process configuration the ","type":"text"},{"text":"Drawer Enabled","type":"text","marks":[{"type":"em"}]},{"text":" option will be by default turned on so that the user can track the process status in the Notifications window. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the steps below to see how to enable this option: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Wait toolbar button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the popup header ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Process Config ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set Run On-Click to Yes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expand Process Config section by clicking on the + icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Process Parameters ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For pWaitSec parameter set the value to 5 ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 79 page 2-value to 5.mp4","id":"e9a4963b-9ad0-4b12-ac1f-0593546c2801","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"collapse advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"save the changes ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"disable the edit mode ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"click Wait toolbar button ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Process started automatically and you can track it status in the notification drawer. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 80 page 2-notification drawer.mp4","id":"ab9145d7-9709-4da6-8f04-c83f8bc323a7","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Advanced MDX ","type":"text"}]},{"type":"paragraph","content":[{"text":"Advanced MDX techniques can be used everywhere in the Apliqo application. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In the following example, we are going to check a few of the most common MDX queries that can be used to improve the functionality and the user experience. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Dynamic filtering ","type":"text"}]},{"type":"paragraph","content":[{"text":"One way to use dynamic filters with the help of MDX is to query a member base on the value of an attribute of another member. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise create a new view, based on General Ledger cube. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Default view ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 81 page 2- Default view.mp4","id":"2d66d19c-203d-4cb2-832d-e8a141329972","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"In this exercise, we will work on making the Currency selection dynamic based on the selected Region. To accomplish this, we will make use of the existing ","type":"text"},{"text":"Currency ","type":"text","marks":[{"type":"em"}]},{"text":"attribute of the Region dimension. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Move Version dimension to columns section ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Move Region column dimension to filters section ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Subset editor for Region global filter dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the subset to All Countries ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change Attribute to Code and Description ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click Apply ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 82 page 2-Click Apply.mp4","id":"27cde901-32f0-4000-98cb-7aa779745951","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"select Currency dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"open advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"select Dimension Settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"in the MDX textbox input following code: ","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"{[Currency].[Currency].[$<>]}","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"close the cube settings popup ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Observe that whenever you change the country, the currency will update automatically based on the attribute. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 83 page 2-the attribute.mp4","id":"0458eddd-c5d5-4552-8639-8390e663317c","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" ","type":"text"},{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Alternative version of the MDX ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"{StrToMember(\"[Currency].[Currency].[\"+[}ElementAttributes_Region].([Region].[Region].[$<>], [}ElementAttributes_Region].[Currency])+\"]\")}","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Define MDX for Currency dimension to display the currency set in attribute of selected Region element:","type":"text"},{"text":"[Currency].[Currency].[\"+[}ElementAttributes_Region] ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set Region element to change dynamically: ","type":"text"},{"text":"[Region].[Region].[$<>] ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Define the Region attribute :","type":"text"},{"text":" [}ElementAttributes_Region].[Currency])+\"] ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2. Filtering displayed elements ","type":"text"}]},{"type":"paragraph","content":[{"text":"The next example will allow us to see only filtered Region elements on the columns based on their value in the selected cube. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise navigate to UX Samples - Filters - Filtering displayed elements in columns by value using MDX ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"change the Version & Account global filter and observe how the displayed elements change based on their value ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 84 page 2-their value.mp4","id":"4e5d0b28-126b-4411-be96-5edb6c901ecf","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"Now we will take a look at the configuration: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Region column dimension ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Dimension Settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the MDX text box you will see following MDX query: ","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"{\n Filter( \n { TM1SubsetAll ( [Region] ) }\n , [General Ledger_C3UX].(\n [Version].[$<>],\n [T Year-Month].[2012],\n [Currency].[Local],\n [Region].CurrentMember,\n [Department].[Corporate],\n [Account].[$<>],\n [General Ledger Measure].[Amount]\n )\n > 1000000 ) \n}","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" ","type":"text"},{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Additional information about used MDX ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Filter all the elements from the Region dimension: ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"paragraph","content":[{"text":"Filter( { TM1SubsetAll ( [Region] ) } ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Filter all elements based on their value in General Ledger_C3UX cube: ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"paragraph","content":[{"text":"[General Ledger_C3UX].([Version].[$<>],[T Year-Month].[2016],[Currency].[Local],[Region].CurrentMember, [Department].[Corporate],[Account].[$<>],[General Ledger Measure].[Amount]) ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Filter values bigger that 1,000,000:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"> 1000000 ) ","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"UX Placeholders for Version ($<>) and Account dimensions ($<>) were added to enable the dynamic change of selected elements.","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 85 page 2-selected elements.mp4","id":"c1b872eb-f4de-47dc-9080-1f47ccf694be","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"In the next part we will update the configuration: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Replace [T Year-Month].[2012] with [T Year-Month].[$<>] to enable dynamic selection ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change YEAR MONTH global filter to 2014 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Notice that different elements will be now displayed in the table ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 86 page 2-in the table.mp4","id":"e20146e6-a40e-49ec-8ec5-ba2783945e00","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Full MDX view ","type":"text"}]},{"type":"paragraph","content":[{"text":"With Full MDX functionality, users can create reports faster, more easily include custom columns and calculations, and still benefit from the placeholder functionality. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Full MDX statements can be added using cube settings popup. After turning on Full MDX option, new textbox will be provided to input query. Dimensions can be left undefined, configured to set the dimensions Attributes or used to incorporate dynamic filter selection with the help of UX placeholders. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For the purpose of this exercise add new widget based on General Ledger cube, you can use any dashboard available. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Then follow the steps: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the cube settings of newly created widget ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Move Period and Version dimensions to global filters ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel by clicking on the wrench icon ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select Widget Settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Turn on the Full MDX option ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Collapse the advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click Edit MDX button ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the textbox input the query provided below: ","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"SELECT\n{TM1SubsetToSet( [Region].[Region], 'All Countries')} ON COLUMNS,\n{TM1FILTERBYLEVEL({[Account].[Account].Members},\n1 )} ON ROWS\nFROM [General Ledger]\nWHERE (\n [Period].[Period].[$<>],\n [General Ledger Measure].[General Ledger Measure].[Amount],\n [Department].[Department].[1],\n [Currency].[Currency].[Local],\n [Year].[Year].[2012],\n [Version].[Version].[$<>]\n)","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 87 page 2-version.mp4","id":"05d78be0-de65-4b6b-988f-3ea6508e028d","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Period and Version dimension where defined dynamically with the use of settings service placeholder to facilitate dynamic data update based on selected value.","type":"text"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"table will be generated based on the added MDX query","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"paragraph","content":[{"text":"Change ","type":"text"},{"text":"Period ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"Version ","type":"text","marks":[{"type":"strong"}]},{"text":"global filter to test the data update.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 88 page 2-data update.mp4","id":"47b9ceef-2cda-4e62-9c85-7c39a4265b83","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"paragraph","content":[{"text":"At this point selected elements from both dimensions are displayed without attributes, this can be easily changed. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the cube settings again ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"move Region dimension to Widget Column ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"move Account dimension to Widget Rows ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the advanced options panel ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"select Account dimension » open Dimensions Settings and change the Attribute by selecting Code and Description from the dropdown list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"select Region dimension » change Attribute by selecting Code and Description from the dropdown list ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Close the cube settings popup and you will notice that selected attributes are visible in the table. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 89 page 2-in the table.mp4","id":"e854288f-5142-4972-868f-80257f452837","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" » Add custom column to Full MDX view ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"As Full MDX functionality allows to easily include custom columns and calculations, in this exercise you will practice that. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the cube settings popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"change the MDX query in the Full MDX textbox to the one provided below: ","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"WITH\nMEMBER [Region].[Region].[All Countries SUM] AS\nSum(TM1SubsetToSet( [Region].[Region], \"All Countries\" ) )\nSELECT {[Region].[Region].[ All Countries SUM],{TM1SubsetToSet( [Region].[Region], \"All Countries\")}} ON COLUMNS,\n NON EMPTY {TM1FILTERBYLEVEL(\n{TM1ToggleExpandMode({[Account].[Account].Members}, EXPAND_BELOW )},\n1 )} ON ROWS\nFROM [General Ledger]\nWHERE (\n [Period].[Period].[$<>],\n [General Ledger Measure].[General Ledger Measure].[Amount],\n [Department].[Department].[1],\n [Currency].[Currency].[Local],\n [Year].[Year].[2012],\n [Version].[Version].[$<>]\n)","type":"text"}]},{"type":"panel","attrs":{"panelIconId":"atlassian-light_bulb_on","panelIcon":":light_bulb_on:","panelIconText":":light_bulb_on:","panelColor":"#B3F5FF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Using WITH MEMBER query you added an additional column, which is not part of the cube, that will show the sum of previously selected elements from the Region dimension (sum of all elements from the “All Countries” subset).","type":"text"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the cube settings ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"table will now display additional All Countries SUM column ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the changes ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 90 page 2-save the changes.mp4","id":"3fedf023-507d-484e-84f4-1e14344118db","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"User default settings ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Set up Home Page ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":" ","type":"text"},{"text":"»","type":"text","marks":[{"type":"strong"}]},{"text":" Use \"Set Home Page per user\" widget to change the Home Page ","type":"text"}]},{"type":"paragraph","content":[{"text":"Each user of the Application can have a dedicated Home Page selected. ","type":"text"}]},{"type":"paragraph","content":[{"text":"This is how we can set it using the ","type":"text","marks":[{"type":"strong"}]},{"text":"Set Home Page per user","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" widget: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"Welcome to Apliqo UX ","type":"text","marks":[{"type":"em"}]},{"text":"dashboard by selecting it from the ","type":"text"},{"text":"Content Store Settings ","type":"text","marks":[{"type":"em"}]},{"text":"menu ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change the Demo1 user home page to “Exec Dashboard” ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Logo and make sure that it navigates to Exec Dashboard ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 91 page 2-Exec Dashboard.mp4","id":"b1131e4b-d11a-4bd9-85d0-e6c90d112b00","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"» ","type":"text","marks":[{"type":"strong"}]},{"text":"Use User Default Settings to change the Home Page ","type":"text"}]},{"type":"paragraph","content":[{"text":"There is an alternative way to set up a Home page. ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the right corner of the page there is a name of the user visible (Demo1), click it ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose ","type":"text"},{"text":"User Default Settings","type":"text","marks":[{"type":"em"}]},{"text":" from the list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the popup open ","type":"text"},{"text":"Set Default Homepage","type":"text","marks":[{"type":"em"}]},{"text":" drop-down list ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choose ","type":"text"},{"text":"Welcome to Apliqo UX ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Close the popup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the Logo and make sure that it navigates to ","type":"text"},{"text":"Welcome to Apliqo UX","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"video 92 page 2-to Apliqo UX.mp4","id":"4472711e-fbc0-43cc-9931-3400d8ec2aec","collection":"contentId-2509045973","type":"file","height":928}}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Final Exercise","type":"text"}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Your task","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":": Recreate a wizard based on provided screenshots. Pay attention to details like colors, typography, formatting and layout. View demo below to check the details.","type":"text"}]},{"type":"embedCard","attrs":{"layout":"center","originalHeight":410.0,"width":100.0,"url":"https://apliqo.storylane.io/share/azulourr4aoq"}},{"type":"paragraph","content":[{"text":" ","type":"text"}]}],"version":1}

Browser not supported