This feature allows you to open forms on specific pages within the system, without needing to change the default form-opening settings. The goal is to provide flexibility, allowing users to choose which page the form will be displayed on, while keeping the default pages as a baseline.
The main functionality is to open forms directly on user-defined pages while keeping opening settings unchanged. This makes it possible to define different pages when accessing forms in a dynamic and customized way.
To create and use this feature, you must enable some user permissions.
In Manager permissions, the user must have the following permissions enabled:
The user must also have DBMS access, with permission to insert and update records in database tables.
You must access your database manager and run the following SQL commands:
Insert Command:
INSERT INTO REP_CMS_CONTENT (dscName, dscContent, dscContentType, datLastModified) VALUES ('UpdatePages', '', NULL, GETDATE())
Update Command:
UPDATE REP_CMS_CONTENT SET dscContent = '
<div>
<span d-on-click="UpdateItemField({{systemPagesValues.Page0Name}},scenario);UpdateItemField({{systemPagesValues.Page0Value}},[Scenario].[Scenario].[&1]);">Realized</span>
</br>
<span d-on-click="UpdateItemField({{systemPagesValues.Page1Name}},entity);UpdateItemField({{systemPagesValues.Page1Value}},[Entity].[Entity].[&2]);">Brazil</span>
</div>
', datLastModified = GETDATE() WHERE dscName = 'UpdatePages'
UpdateItemField({{systemPagesValues.Page0Name}},scenario);, the scenario parameter stores the dimension name that will be opened as pages;UpdateItemField({{systemPagesValues.Page1Value}},[Entity].[Entity].[&2]);
[Entity].[Entity] represent the dimension and hierarchy, respectively;[&1] parameter represents the identifier in the dimension member property;Realized is the label that will be displayed in the content box on the T6 dashboard;To ensure correct behavior, the identifier parameter must always be different from the identifier of the member defined as the default page for opening the form;
In this example, only 2 options were created, but you can create as many as needed. The commands remain the same; only the fields
Page0NameandPage0Valuemust be changed by replacing digit "0" with the next one, as shown withPage1NameandPage1Value. If a third option is needed, you can add another<span>, changing only these fields, for example:<span d-on-click="UpdateItemField({{systemPagesValues.Page2Name}},time);UpdateItemField({{systemPagesValues.Page2Value}},[Time].[Time].[&8]);">January</span>;
To check a dimension member identifier, go to the T6 main menu, open Modeling, then access Designer;
For correct behavior, click the items shown in the content box in the order they are displayed, from first to last.
For example:
The second displayed item depends on the first to work, but the first item does not depend on the second.
Visit our Help Center for additional information about Dashboard.
Open Worksheets with Specific Page Values is a T6 feature that allows forms to be opened on specific pages in the system without changing the default opening settings, providing flexibility to dynamically choose which page the form will be displayed on.
When opening forms in T6, default pages are the fixed form-opening settings, while specific pages allow you to temporarily define different values, opening the form on the desired page while keeping default settings unchanged.
To use this feature, users must have the following Manager permissions enabled: Create and View Dashboards/Maps, Manage the Data Table Structure, and Manage the application structure/model.
They must also have DBMS access (Database Management System) to perform inserts and updates.
The initial content must be inserted into the REP_CMS_CONTENT table in your database.
After accessing your DBMS, execute this SQL command: INSERT INTO REP_CMS_CONTENT (dscName, dscContent, dscContentType, datLastModified) VALUES ('UpdatePages', '', NULL, GETDATE()).
Yes. After inserting the initial content in the DBMS, just add more spans in the UPDATE command, changing fields from Page0Name/Page0Value to Page1Name/Page1Value, Page2Name/Page2Value, and so on (for more information, see: Specific page values).
To find a dimension member identifier, follow these steps:
When creating or editing a Dashboard, create a Content box and select template UpdatePages (created previously using SQL command), then create an Explorer box to access forms (for more information, see: Dashboard).
Because for the selected form to open on the desired specific page, the click order must be respected: The second item depends on the first item to work. If clicked out of order, or only the second item is clicked, the form opens with default pages.
Check whether:
The used identifier is different from the default identifier;
You clicked in the correct order (first item, then second item);
User permissions are correct;
SQL commands were executed correctly in the DBMS.