I need to create what seems like a simple report that shows storage devices and their used capacity. This is very easy to do but I need to add a column to the table that shows the licensed capacity so I can then calculate the used vs licensed capacity. Licensed capacity needs to be input by the user on a per-device basis. Is there a simple way to do this?
Just create a prompt for the user to type into, say ?Licensed Capacity? then in your query just bring that in as a column.
Every row needs a different entry. I've tried to figure out how to make a prompt that asked for each row but I couldn't figure it out.
Sounds like you need a table in your database to hold those values then. Or alternatively perhaps a spreadsheet that you can bring into your report as external data...
There is, in fact, a very cute technique for creating repeating prompts and using their values. Like most cute techniques you get, it was developed by Paul. Check out the bottom part of this post: http://cognospaul.com/2014/01/02/creating-data-entry-page-cognos/ (http://cognospaul.com/2014/01/02/creating-data-entry-page-cognos/)