i have a field ..called purch doc no .. this needs to be in the report ..
the architecture is like this ..ODS Level 1 -
so ODS Level 1 - is not opened for reporting and we cant take this field (
Purch doc no ) to the Cube as it is too granular ..
how is it possible to report on the field which is available on the ODS ..
and not on the Cube ..
we can only report from cube ..its not possible to create multicube ..i have looked at that too .. also looked at jumpquery , RRI ..etc ..
plz can anyone give suggestions plz ...