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

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

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

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

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

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

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

Name the types of report?

0 Answers  

Are you aware of any limitations in Cognos?

1 Answers   HCL,

------------------What is Inline Query?

0 Answers   Cap Gemini,

what is degenerate key in oracle ?whare do we use it?

0 Answers  

what is field set? what is the query calculation and layout calculation?

2 Answers   Syntel,

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 Answers  

what is an associated query?

2 Answers  

Can you define a query subject?

0 Answers  

How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).

1 Answers  

------------What is Slicer memberset?

1 Answers  

what is stitch query?

2 Answers   Syntel,

pls ans what are the filters we have in framework manager? filters in report studio?

3 Answers   IBM,