I am creating a webi report on SAP universe.
Whenever I apply any date related formala on the date field , all the values in the measure becomes #error or #available .
Additional informaion :
it has got say 6 fields like Cusotmer , sales material and Date ( making it one dimension) and Profit , quanity sold and amount as measures.
I created a formaula on date field and added 4 days to the current date.
Now what happens is if I dragged this new formaula object to webi output area all my measures become #error or #un available.
When i remove this newly created formaula from result area , all the values comes back .
This happend also when I wanted to find out the name of the day on a particular date and drangged onto my resultant area.
After this all the measure values in the webi got #error or #available error.
Any help is highly appreciated.
Thanks & Regards,