I want to display link (or template view) to a specific file, where the file depends on the role of the logged-in user.

As an example:
Logged in as Admin, let's say I can see the following folders and files in DMX:

Coke (folder)
-recipe.xls
-sales.xls

Pepsi (folder)
-recipe.xls
-sales.xls

The permissions are set up such that when a Pepsi user is logged in (role: Pepsi_Users), he or she only sees the Pepsi folder and its contents -- not the Coke folder. This all works fine.

Now, what I want is a "Sales" page that only displays the sales.xls file for the role of the logged-user (i.e. Coke or Pepsi). Ideally it would appear as a link, but the Template view might suffice if that's not possible.

Thoughts? Thanks in advance for any help.

My thoughts on this are that you will need to have several sales files next to each other in a folder. This folder is the root of that DMX instance and each file will have individual permissions set on it to make sure it only shows up for the intended audience. As they're all in the same folder you'll want to give them distinct names so admins don't get confused.

Peter