This content has been marked as final. Show 4 replies
Hi,1 person found this helpful
Hitting a 'NULL' value in the report hints me of some issues with the Hierarchy/Content setup of the LTS. I suggest you to enable level 7 log and see if the AGO(<measure>) is being nullified by the BI Server due to incompatible facts.
If it is, then you got to revisit your Period hierarchy and content settings in the Fact LTS. Some generic suggestions are,
1. Create hierarchies for all dimensions available.
2. Set the granularity of the sources in the fact to all available hierarchies.
Hope this helps.