Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 17981 Views
- Cognizant, Cognos, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name
What you mean by drill across?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
what is the use of lock and unlock
where exactly determinants are used in cognos framework manager?
What is called Cognos powerplay?
hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........
what is the difference between cognos8 fm and cognos reportnet fm?
What is Clipboard? How to import XML file into Clipboard?
9. What was the most complex type of report you dealt with?
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
Teradata 
