In which type of report we can create school time table in cognos? [I want per

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,,,,,

Question Posted / kranthi

2 Answers
6640 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In which type of report we can create school time table in cognos? [I want period numbers in rows ..

Answer / 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

In which type of report we can create school time table in cognos? [I want period numbers in rows ..

Answer / beckham

My suggstion is that you can go for a list report as the
number of items in rows and columns are static in this case
and you need a descriptive item or dimensio in the
middle.... Crosstab can better be used for SUMMARIZED data
across both dimensions.. For DETAILED information like our
scenario you can use the LIST itself...

All the best...

Is This Answer Correct ?

1 Yes

1 No

Post New Answer