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
- 7602 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 |
what is mean by cognos powerhouse?
Can you define cube?
What is the difference between a cascading report and drill through the report?
Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What is parameter maps & Session parameter?
what is #prompt and #promptmany, runningtotal in report studio
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
what is requery in cognos?
What is main difference mapplets and mapping?
how u migrate the reports from impromptu to reportnet???
Teradata 
