Search results for query: *

how to use zero is null and null is zero in metric give with example

thanks a lot Griffin.

hello all, i'm a newbie and forgive me if this too silly. when doing a report in impromptu using filters when i say select values it displays only 100 unique value and says Picklist limit has been reached. how do i make it show all the unique values of a given column. also in prompts when the...

can anyone tell me some basic advantages / disadvantages of Dimensional Modeling and ER Modeling. thanks

yes you are right dave. end users shouldn't be using sql to generate reports. i have done it in sql but the thing is i don't want those users to execute sql directly instead use powerplay to generate it for them for ease of use. there is no effective start date and end date instead we use...

Dave Griffin, Many a thanks for your patient reply. Instead of creating a hotfile from Impromptu I can create a table which aggregates what you have said to do in Impromptu (The structure of the report to generate the hotfile will be: department, employee, Max(Project), and Max(assign date))...

Dave Griffin , Thanks very much for your good reply. Regarding my question 5 let me make it clear. Suppose I have created a cube which contains measures and dimension attributes as well. Is it possible to do a report in Powerplay where i don't use the measures instead use only dimensions and...

Hello All, Could anyone help me to accomplish this. I've being assigned a task to do a Dept wise Employee Productivity Report. The scenario is I have a table which contains details of employees assigned to each project, which may vary time to time, but a employee will be assigned to only one...

Hello All, I'm new to Cognos. I have a few basic doubts. 1. What is the relationship between Impromptu and Transformer. I was told that one could do reports in Impromptu itself then why should we need Transformer and Powerplay. 2. What is the purpose of calculations and conditions in...