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,,,,,
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
How to publish a package by running Java Script?
Can you define drill down and drill up?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
--------------Diff b/w ODS and OLAP?
What is the difference between low affinity and high affinity connections?
Can you define drill across?
Why is auto-regression used in forecasting used on cognos platform?
What is zero-foot print?
Can you define report item?
what are the dimensions that you have in your current project?list them?
What are shortcuts? Where it can be used? What are the advantages?
write a query to display the departments with no employee?
----------------------What are the User Securities?
What are the types of studio?
What are the different types of reports present in cognos?