what are the joins present in reportnet?which is most
widely used?
Answers were Sorted based on User's Feedback
Answer / jay
inner join and outer join . mostly inner join is used in
reportnet.
Is This Answer Correct ? | 3 Yes | 1 No |
Tell me about Dnamic and Static Dashboards?
Can you define a catalog and types of catalogs in cognos?
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
Where do you set security levels for users in reports?
How to create multilingual reorts?
Can you explain new content durability?
How to create a Left Outer Join in FM? Please explain.
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
what is the use of lock and unlock
what is the generated prompt,how can i use?
is there any possibility to hide items other than render variable?
how data modeling is usefull to cognos?