Skip to Content
0
Former Member
Jun 02, 2005 at 04:48 AM

Query question: Objects in InfoCube,but says "not assigned in query

10 Views

Hi All!

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.

GL....IO.. CostCenter....Amount

123....2....26.............500

123....3....26...........1,000

125....2....27...........2,000

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 what’s wrong why I can’t filter using that IO object but it’s 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