Calculated field using olap cube

Rory Miller shared this question 6 years ago
Answered

Hi,

i am using two appends to filter this and last year onto two dimensions in my table but when i want to calculate the difference using a calculated field i get thrown an error. 'Error retrieving results An error occurred retrieving results from the databse' any ideas why or how i can around this?

Replies (3)

photo
1

Hi Rory,


From your description alone, it is quite hard to tell what might be going wrong here. Can you please attach and send me your entire logs folder, slightly after you have replicated this error?


You can find the logs in your Yellowfin installation folder (yellowfin/appserver/logs)


Regards,

Nathan

photo
1

have found a work around using advanced functions to work out the variance between two columns

photo
1

Hi Rory,


Glad to hear you found something that works. I am going to close this one for now, but If you run into this again, or want to pursue this further please let me know (the best place to start here will be the logs).


Regards,

Nathan

Leave a Comment
 
Attach a file