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

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

How to write the necessary TSQL to create data sets, pull the
data sets in Cognos Report Studio WITHOUT using framework
manager.

Question Posted / divya.k

Answer Posted / divya.k

1)In Cognos Connection Page go to Launch and select IBM
Cognos Adminstration.
2)Select Configuration,select data source connections if the
selected data source is not there in the list.
3)Select New data source icon and create data source that is
in TSQL.
4)Now open report studio and click Query Explorer and select
Queries.
5)Drag new query in insertable objects into the page and
drag SQL from insertable objects right to the corresponding
new Query .
6)In Properties SQL select corresponding data source and
write the syntax n validate it.
The above steps can be done without publishing the package
through FMW in COGNOS.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How create measures and demensions?

1088

what are the errors faced while bursting the reports and how to solve those errors?

2063

What is the difference between Standard and Metrics folder?

1123

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

2118

what is requery in cognos?

2530

What is Bitmap Index?

1098

how to explain health care project and which reports we can create in health care doain?

6846

How to publish a package by running Java Script?

2126

How to generate cubes in cognos?

1013

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1939

How can you link a query to a data container manually in Report Studio?

2401

What is the function of model design accelerator?

1003

Why cognos decision stream is used?

1201

Can you define set to be cardinality?

1057

Can you define folder?

1022