I have some questions with my query. To simplify it, let me illustate it using the example below.
I have values in the cube which shows like the one below.
I am making a query, wherein I want to display only the amount for IO 2 for GL 123. I restricted my query with the defaults for IO and GL. However, when I run the report, it showed me no values.
I try making again query with IO ( no restrictions) as my row and amount as my column, the column for amount showed 3,500 but the IO was Not assigned. I did the same thing, using cost center as my row and it showed me the breakdown of amount per cost center.
Could you pls tell me whats wrong why I cant filter using that IO object but its working fine using the other objects? I already had master data for IO, the cube contents is ready for reporting.
Pls enlighten me. Thank you