3 of 4 people found this helpful
Looks like again BMC achievement to keep the customer away using the YellowFin features.
Here is the document link from BMC Creating calculated fields - Documentation for BMC Remedy IT Service Management Suite 9.1 - BMC Documentation
Same link from YellowFin in ver 7.3 ( which is same as 9.1.03 or 9.1.04 bundled with) Calculated Fields - Yellowfin Guide 7.3 - Yellowfin Wiki
Disappointing that BMC is taking away functionality.
7 of 7 people found this helpful
I can see the Freehand SQL option in 9.1.03
You may find that you can't see the Freehand SQL option because of your Role settings.
Get your admin to check the settings for your Role under Report Builder, there is an option to 'Allow Frehand SQL Calculated Fields' that needs to be ticked
I have Admin permissions.
This was an upgrade from 9.1 to 9.1 SP3.
1 of 1 people found this helpful
I have verified as Jo Boniface pointed out and it worked. Login to smart report as siadmin user and click on the Admin Role and navigate to Report builder option and check the Allow Freehand SQL option and save and then login as your remedy user and you will see the Freehand SQL in the drop down list.
I hope this help.
Interesting ..... the 'Allow Freehand SQL Calculated Fields' was turned off for the Admin Role, but turned on for the Corp Writer Role.
We upgraded from 9.1 to 9.1 SP3 patch 1.
How to custome smart reporting using Select * from with metohod freenhand sql ?
Sorry Pahman, I'm not familiar with that command. I would post this question on the forum.