I have a report that runs against a Cube in Cognos. In report studio, I have two date prompts to control the data. What dimensional functions can I use for the following situation?
Since there are no members for Saturday in the cube, setting the from date prompt to Saturday will give an error. What I would like to do is, check in Cognos whether the user selected a Saturday and have Cognos use Friday or Sunday. Can this be done with dimensional reports?
Please Assist. Thank You,