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

Can we create a report in cognos BI without a Package? i.e.
without framework manager? If so how? I have been asked this
question twice..i think this feature is available in cognos
10 version..not very sure....Could anybody highlight?

Question Posted / alisha.nathawat

Answers were Sorted based on User's Feedback



Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I..

Answer / nasa

ya we can create....

Report Studio-> Query Explorer->Queries-> drog SQL -> write a
query and validate that-> drag and drop particular data items
into window from data items tab... or drop into work area and
run it....

Is This Answer Correct ?    15 Yes 7 No

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I..

Answer / banucr

Imagine opening report studio without a package? so the answer is 'NO'. At least we need a dummy package to open report studio as well and from there we can create a new report by writing our own SQL query in query explorer

Is This Answer Correct ?    7 Yes 0 No

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I..

Answer / alisha

Hi Yunus,

Here the requirement is without FM..i.e. without the package
...so if we use the sql query..like for eg. we do select *
from _____??? ultimately we will have to reference a data
item i.e. the package, we don't want this.

And yes we can import excel through ODBC after doing system
dsn settings and all but again we do that in the framework
manager while importing the data source... the question
asked was can we do it independently in report studio with
no acess to FM or the package..if so how..can you let me
know the detailed steps if there is such an option available
because i don't think there is any as far as i know..pls
confirm!!

Is This Answer Correct ?    4 Yes 2 No

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I..

Answer / stan

Alisha,

You dont have to reference the FMW package anywhere.
Just do the following
Report Studio-> Query Explorer-> Queries-> drog SQL -> write a
query and validate that against the database-> once it is validated all the items will be found under the SQL from where you can select it in as query items

Is This Answer Correct ?    4 Yes 4 No

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I..

Answer / rahul

Yes, we can create report without using FM Package.
Use SQL override -Go to Query Explorer -On left Topside -SQL override-Drag it and go to properties (Bottom Left) -select the source and set Native SQL/Passthrough SQL (Dont use IBM Cognos Sql).
SQL Override is not prefered method( we are missing minimised SQL concept).

Is This Answer Correct ?    1 Yes 3 No

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I..

Answer / alisha

How...as in if suppose u write a sql query..select * from_____??? You will anyways have to reference the pakage ...
And we do have options to import excel through odbc by setting system dsn and all...but again that option is un framework manager... how do we do that in report studio without any package without fm... if you are aware that this is possible please let me know the detailed steps..

Is This Answer Correct ?    0 Yes 4 No

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I..

Answer / yunus

Yes we can create a report with the framwork package,
either by sing a SQl query in the report or buy importing
the excel data in the report(only in cognos 10).

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Cognos Interview Questions

What is the use of powerhouse?

0 Answers  

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

How can we do the unit testing?

3 Answers   Logica CMG,

How do we implement Check Box Prompt in COgnos Report Studio?

2 Answers  

what is #prompt and #promptmany, runningtotal in report studio

1 Answers  

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?

0 Answers   HCL,

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,

How to do Performence Tunning in Cognos Reports?

0 Answers  

How you will do the estimation for a task?

1 Answers   iGate,

what is the use of layout component reference

3 Answers   Satyam,

how to create measures and dimensions?

0 Answers   IBM,

What is meant by alternate drill down with ex?

0 Answers  

For more Cognos Interview Questions Click Here
Categories