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
- 7595 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
What are the other methods working as deployment functionality?
Can you explain dynamic query mode?
What is the difference between ‘macro’ and ‘prompt?
What are the different kinds of panes included in cognos?
How to create a cube in Transformer? What is the process? Please mention process thank u
7. What is performance tuning?
What are all the types of report?
Can you define set to be cardinality?
---------------Tell me about DWH Concepts?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
How can we Maintain the Cube Security by Category level and Dimension level ?
what is log in cognos?
Can you define a catalog and types of catalogs in cognos?
what is requery in cognos?
