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,,,,,
Answers were Sorted based on User's Feedback
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 |
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 |
Where do you edit cognos sql in report studio?
Explain the Difference Between Bursting and Scheduling?
what is view? types of views?
can anybody tell me when do use 'running total'...give an example for the usage of running total
------------ Diff b/w MemberCaption and MemberDescription?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
How to select all in value prompt instead of cascade prompt?
--------------what is MemberCaption?
Diff b/w surrogate Key and Primary Key?
It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?
fiscal year means what???