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
- 6648 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 is the report studio?
how to merge 2 crosstabs thans
What is the difference between Standard and Metrics folder?
what are the dimensions that you have in your current project?list them?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate what r the reports u faced critical and how it can be solved
.. any once can u give a best ans for interviw What are the ways to import data into catalog? What are initial page components of Cognos connection? How can create users and permissions in cognos? What do you mean by drill across? plsreply to me...im interested to do the cgnos
certifications relating to report developer.can you suggest
me what kind of certifications andwhere cani get (dumps)
previous quetions and answers for the certification........
how to develop dynamic dashboards, and what is the difference between static
and dyanmic dashboards in report studion and need with example. plz mail me
on this email id vasucognos4@gmail.com describe the starschema grouping ?how can i add a new column
for existing report ,when it is not present even in model &
dataabase? Write various indexes used in cognos? What do you understand by the term 'dynamic cube'?
