First, create the file “Content1” with the following view:
To enable the use of variables, detach this view (Jedox→Detach View).
Next, create the file “Content2” with the horizontal DynaRange “Months” in C3:C5 and the vertical DynaRange “Products” in B4:D4. In C4, add PALO.DATA () with the option “Guess arguments”:
In Content1, enter in the cell E3 =@Year and replace in Content2 in the function PALO.DATAC() “All Years” with @Year and “All Versions” with “Actual”.
Then create the file “Navigation” with links to Content1 in C2 and to Content2 in D2. In H4, create a ComboBox with the subset of the dimension “Years” as source and with the destination “Year” as a variable:
Now save and close these 3 files. Using the right mouse button, select the command “Mark/Tag… – As frame” for all 3 files (you can only add tagged files to a frameset).
|As next step, select
the command New→New frameset”:
In the dialog window, set the following options:
Heights: 80 px;
|Insert file Navigation.wss in Frame1 and set the following properties for Frame1:|
|Insert file Content1.wss in Frame2 and set the following properties for Frame2:|
The checked options for the frame properties take effect only in user mode.
A frameset can be established with one frame for export as XLSX Snapshot, PDF, or HTML. Without setting the frame, the export will be randomly selected.
With the “Add” button, we get the new frameset file and name it “Frameset1”. Right-click on “Frameset1” to go back to Properties→Frameset.
Now double-click on “Frameset1” to adapt the hyperlinks:
Right-click on “Content1→Edit Hyperlink” to get the following options for “Display in frame”:
- _new (opens Content1 in new tab)
- _self (opens Content1 in Frameset1 tab)
- _top: closes the current frameset or current file and opens link in the same tab
- Frame1 (opens Content1 in Frame1 – in our example used by Navigation)
- Frame2 (opens Content1 in Frame2)
For this example, choose “Frame2” for both “Content1” and “Content2. Then save and close “Frameset1”.
Now switch to the Reports module, drag the file “Frameset1” onto “Hierarchy”, switch to the user preview, and click “Frameset1” twice. If you select the year 2015, the following screen appears:
With the link “Content2”, the following view appears:
Thus we can comfortably set the year with the ComboBox and quickly switch between “Content1” (Regions data) and “Content2” (Quarters data) with the hyperlinks.