Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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,,,,,

Answers were Sorted based on User's Feedback



In which type of report we can create school time table in cognos? [I want period numbers in rows ..

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

In which type of report we can create school time table in cognos? [I want period numbers in rows ..

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

Post New Answer

More Cognos Interview Questions

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  


What is Render Variable? where u can use?

3 Answers  


what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

4 Answers   IBM,


what type of charts we create mostly in realtime? plz help

4 Answers   IBM,


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  


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........

0 Answers  


What is a Folder?

0 Answers  


Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,


How security is concerned with Reportnet? Explain its implementing steps.

0 Answers   iFlex,


how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please

6 Answers   TCS,


cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  


What are the types of security?

0 Answers  


Categories