TM1 Forum

I have a lookup cube (let Say Cube2) where calculating mix by looking up values from Cube 1. Cube2 is empty and it has values derived from some calculation based on the values from cube1.

When I create view(suppress zero is enabled) in Cube2 to see the derived values, I was unable to see any values. But when I use DBRW function to retrieve the values from Cube2, I could see the values.

Rules between Cube1 and Cube2 are fine.

just for testing what I have done is I have included a measure called FLAG in the measure dimension of Cube2 and using a process I have place 1 in each and every instance. After that when I refresh cube2, I could see the values.

Is it mandatory that in cube should have instance for that value to show in view i.e, cube cannot show derived values from another cube, unless there is an instance of that value?
Is there special rule based function or some thing this issue can be avoided?

Can anyone help me in this regard?

Thanks in advance.

ryan wrote:When I create view(suppress zero is enabled) in Cube2 to see the derived values, I was unable to see any values. But when I use DBRW function to retrieve the values from Cube2, I could see the values.

Did you forget to write feeder statements for your rules? Sounds like a classic feeder issue. Either read the manual or search this forum for information about writing feeder statements for your rules.

tomok wrote:

ryan wrote:When I create view(suppress zero is enabled) in Cube2 to see the derived values, I was unable to see any values. But when I use DBRW function to retrieve the values from Cube2, I could see the values.

Did you forget to write feeder statements for your rules? Sounds like a classic feeder issue. Either read the manual or search this forum for information about writing feeder statements for your rules.

FEEDERS statement is available and feeding is correct as well.

Post your rules code. Can't help you without it.