08-09-2022 10:58 AM - last edited on 05-24-2023 11:36 AM by JackLacava
I have this Cube View that I have to format so that the highlighted department column information is hidden but I still need to show the user what department this report is for (there are several that can be picked when you run the cube view).
Any ideas on how I can go about these two issues?
Thank you for your time in advance!
08-09-2022 02:36 PM
Couple options here. I would put the department somewhere in the report header referencing the UD1 parameter in your screenshot. For the rows of the report, try the following:
08-10-2022 12:55 PM
I am trying to move in the direction that you suggested but it is not working for me, when I run the cube view I loose all of the rows. What am I missing here?
08-10-2022 02:13 PM
I think that looks fine unless you have a typo on the account or UD1 member names/parameters. Can you send a screenshot of some of the other rows to validate those member formulas are also correct?
08-10-2022 03:22 PM
Here are a few screenshots. I do not think that there is a typo as I am prompted to select a department from a list when I run the report and then when the report runs there is no error message for a row having an error, just no rows at all. This is odd.
08-10-2022 03:42 PM
As far as I can see, everything above looks good. My company uses the same account/department setup as you are illustrating, so I was able to refer to some existing cube views that use this member filter setup. This may be a silly question, but did the report run properly before you tried the member filter that I suggested?
08-10-2022 04:29 PM
Hello,
Yes the report ran properly, I copied it and modified the copy and after the modifications it does not run properly any longer. I appreciate your help!
08-11-2022 07:28 AM
Hmm, that is odd it isn't working. Maybe someone else in the community can catch something I'm missing or provide you an alternative!