Hey gang,
I have a report requirement where a user can enter in a currency conversion rate, which will change over time and user, to represent their local currency monies and another fixed currency, i.e. always dollars.
I'm okay with doing this for one currency (don't need a prompt for this anyway), but my issue is depending on their other prompted requirements (country, date ranges, etc) they may cross transactions which are in multiple currencies.
How can I enable the user to enter in a conversion rate against each of the returned currencies? Is this dynamic array possible?
Any advice will be much appreciated.
BTW I'm only a Power User on this system so am limited on functionality, permissions on scripting and the like.
Hi,
Cognos 8 BI is designed to be a read-only tool, so you really need to investigate coding or buying a web-based data entry application to accommodate entry of your currency data.
Regards,
MF.
Thanks MF,
As mentioned I can easily get them to enter in one % rate via a text prompt. I was simply hoping that I could simulate multiple entries without making it a fixed number of prompts.
As with most corporates I'm restricted by permissions and access to tools otherwise I would have looked at other means. I'm presuming this just isn't feasible then??