I'm trying to test drill through to FDM thru HFM.
I've enabled 'Drillable Region Load' and 'Use SSO' in web client. We have also defined FDM application name in HFM.
When I cliick drill through from HFM data grid, I get below error:
*'An error occured logging into the system using single sign on. Error 2067- You do not have access to the application.*
Even though 'http://<server name>/HyperionFDM/AuthorizedPages/IntersectionSummaryByLocation.aspx' appears to me, I see
workflow status blank for all 4 steps
Please let me know if I missed out anything.
Thanks in advance
think i might have been wrong in thinking the user might needto be defined in FDM (not set up drill back since 2006/7 and might have been different then.
If you look in the shared services document, there is an option for ERP integrator roles (do a search on Table 40) - is the user you are using assigned a role (or the specific security right) which allows the drill-through secirity?
Not silly - I suppose logically i should have thought about it a bit more before giving my two penneth. I just read the bit that stated that it applies to ERP Integrator and FDM and maybe got 2 + 2 = 5. (As FDM can be strange animal at times though, it might just be worth a try!)
Another thing i have seen from a smartview issue relates to the SSO token timeout. If the token times-out before the timeout on the applications then you can get this message. Might be worth a look at the setting. However, i still think it might be worth a punt at setting up a user on FDM to see if it works.
sorry but just remembered something else. - Have you checked what authentication options have been defined on the FDM load balance server. For SSO you used to need to define your own SSO vbscript in the SSO authentication script but i think this might have been superceded by the Shared services authentication (CCS) if shared services is being used.
Edited by: user10757003 on 19-Mar-2013 13:46
Thanks for your quick reply..All the FDM dimension names are same as HFM dimensions names. Also, if there is any disconnect in dimensions..will it give 'No access to application' error...Just wondering
That is correct. FDM and HFM are using Single Sign on (SSO) to pass the logon token from HFM back to FDM. The user you are are logged into HFM with is not a valid user in FDM, it will return the error you are seeing.
You should be using unified authentication between the two products, where the user you use to login to FDm is used to load data to HFM and Vice Versa on drill though.
We are using Global logon method.Can we achieve drill through with Global logon.
Also, when I enable SSO in FDM settings,dataload fails at 'Validate' step.How can I enable SSO and have data loaded successfully as well