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
- 16716 Views
- Cognizant, Cognos, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the different types of views used in cognos.
What are initial page components of Cognos connection?
What are the components of the report studio?
What are the steps to import the two data sources in framework manager?
Can you define dimension?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
What is model filter?
how to create cubes in transformer ?
i have one file i saved in csv how can i take these file into framework manager
Explain about scorecarding?
What is called a slice?
what is the difference between list report and crosstab report?
Can you define cognos impromptu?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
Can you define cube?
