Citrix Local Connections for all users

[Former Member]

Hi,

We are using SAP BPC 10 Microsoft platform. I have installed office, web and admin clients on the Citrix box and would like to publish them as a published app so that all users can access it. I have logged into to the server as an admin and created local connections to all the Models in the environment. But when I log in as another user I don't see those local connections, how can I make them available for all users?

The EPM Add-in guide says to put the .OQY files in a folder everyone can read but I can't seem to find those in the directory the document says would recide. The directories the document asks me to check is "C:\Program Files (x86)\Common Files\odbc\data sources" and "C:\Users\admin\AppData\Roaming\Microsoft\Queries" but I can't find them on the Citrix server.

Could someone please help!

Thanks.

[Former Member]

Hello Srinivas,

When you can't find those directories you can create new one which is visible by all users. Then you can add .oqy to that location.

Regards,

Mahmoud

[Former Member]

Hi Mahmoud,

Thanks for your reply. But I cannot find the .oqy files for the local connections I have created anywhere. I have checked the following directories too ("C:\Program Files (x86)\Common Files\odbc\data sources" and "C:\Users\admin\AppData\Roaming\Microsoft\Queries") but without any luck.

Thanks.

[Former Member]

Hi Srinivas,

You need to create local connection.

When you go to Create... in the Connection Manager, make sure you pick the "Local" connection type instead of the BPC type.  For the OLAP provider, you can use "Microsoft OLE DB Provider for Analysis Services 10.0".

Hope this helps.

Mahmoud

[Former Member]

Hi Mahmoud,

I have created the local connections. But when I log in as another user I don't see those local connections. Where can I find them? In other words, where are the oqy files stored on the server so that I can copy them to a folder where everyone has access.

Thanks.