MULTIUSER. To implement this method for multiple users, one would have to incorporate database security with @User. This is currently out of scope of this tip and will be covered in a future video.
IMMEDIATE USE. The techniques demonstrated here would be immediately useful to an analyst or manager that wanted to control what was seen by other users. Alternatively, developers could use this technique in place of SQL filtering and dataview configurations.
Because the SELECT cube uses checkboxes, which resolve to 1's and 0's, the cube can be used in cube based selections. This fact opens up number of flexible possibilities for dynamic reporting models; custom calendar entities and years can be used in the SELECT cube. Month end / year end advancements could be easily controlled and rolled back for example.
VIDEO QUALITY. I'm using new software; OBS for screen capture and SHOTCUT for editing. I have not got the resolution quite right and so all BOARD screens are a bit blocky. I'm sorry for this and will re-shoot the video once I know what I'm doing with the settings. However, I felt that the video was watchable and so considered it more important to get techniques out there than wait until I've been able to polish my video skills.
FEEDBACK. I welcome feedback regarding this technique. Advancements on it or fiendishly simple alternatives are especially welcome.
Want to share additional material with other BOARDVille Citizens and the Community? Feeling like you would share a BOARD Capsule? Make sure information is anonymized and no sensible information is shared. Simplify and reduce the size of the application/solution, to the screens/procedures if necessary
NOTE: All inspirations will be reviewed before publication. Usual time to publication is 24h. You will be notified when the document will be published and contacted directly in case something requires your attention/intervention