Hi, How the relations will be exists in DMR models if u have
any idea please explain me
Answers were Sorted based on User's Feedback
Answer / amar
Scope relation ship, between regular dimension and measure
dimension.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / chiru
After completing ur DMR Models, u will get Dimensions Tables i n Dimesnsion Tab and Measure Tables at Measure Tab on..If u want to check whether is relation between Dimension Table and Measure Table, just click on Measure Table, then an yellow colour display on dimension table, it implies relation is there between both tables.. . On right Corner in framework Manager there is scope icon.. by using scope icon we can set the hireriachy levels in relation between Both tables.
For example In Dimesion Table we have Region---Country--- city
By using scope we can set the relation uption Country Level only..............
| Is This Answer Correct ? | 0 Yes | 0 No |
HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?
what is the difference between group and association?
how you provide security to reports? How you provide security to packages ?
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.
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
What is the size of database for you project?
difference between stored procedure and function?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
------------------What is Inline Query?
Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting
How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?