Interested to Buy Any Domain ? << Click Here >> for more details...
In which type of report we can create school time table in
cognos? [I want period numbers in rows like period 1,
Period 2, period 3, period 4, period 5 and class numbers in
columns like 8th class, 9th class, 10th class and subject
names in cells]
Genelally school time table is prepared in crosstab report,
but subject names are not measures and a crosstab cell can
not contain non-measures. This is my problem,,,,,
- 2 Answers
- 7610 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / ash
Step1: Create a crosstab with row as Period and Column as
Class Number.
Step 2: create a data item Subject as
case subject_name
when 'English' then 1
when 'History' then 2
when 'physics' then 3
...
end
step 3:pull this data item as measure cell.
step 4: create a conditional string variable with
expression as
=dataitem
Create values for this variable as your subject names eg,
English, History, Physics etc.
Step 5: Apply this conditional variable on measure cells in
crosstab. Set conditional text for different values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
explain how to create powerplay reports?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is the deployment requirements used in cognos?
How can I schedule reports in cognos?
What are shortcuts? Where it can be used? What are the advantages?
What is the use of powerplay web viewer in cognos?
What is set to be Cognos configuration?
Can you define framework manager?
What are the different types of reports present in cognos?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
Can you define set to be cardinality?
What are the message flows?
What are all the advantages of Cognos?
Tell me about Dnamic and Static Dashboards?
What is called Cognos powerplay?
