Search Results

Search results 1-5 of 5.

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Effects of rights on hierarchy views

    chrisj - - General

    Post

    Hi All, According to the following documentation, restriction on child nodes will not affect the aggregated parent element. But we have the following requirement which is very common among customers Department Hierarchy has the following structure ALL - 10 - 20 - 30 - 40 - 50 User A has the following access rights: ALL (D) - 10 (D) - 20 (D) - 30 (N) - 40 (N) - 50 (N) According to the above, the report should display the sum of Dept 10 & 20 when the user select 'ALL' from the Dept Drop-down, but …

  • MACRO -> currentuser()

    chrisj - - Jedox Web

    Post

    You can use the =currentuser() on a cell as a formula and the fetch the value of the cell in the macro

  • Hi All, We have the following requirement. - User A logs in and opens Report X (filtered for Company 1, Department 1) - User B logs in and opens Report X (filtered for Company 1, Department 2) - We have a job which reloads data based on 2 variables (Company, Department) Now when User A clicks the 'Reload' button this starts the job "Reload Data" (for Company 1, Department 1) via macro. While the above jobs is still executing, if User B clicks the button 'Reload' this should then Start the job 'R…

  • You could use a groovy field with IF condition 1. check if the source column value has a "/", if so format in the particular format and convert to a standard format like dd-mmm-yyyy 2. check if the source column value has a ".", if so format in the particular format and convert to a standard format like dd-mmm-yyyy

  • In our current instance there's a lot of testing going on and before go-live we will need to clean up all these testing and have only a selected dataset. For example.. While testing on forecasting, there has been many future forecast versions created as well as test transaction data has gone into many cubes. For go-live, we need to delete the above mentioned test forecast versions as well as the corresponding transaction data in multiple cubes. What would be the best practice for this Regards Ch…