How many fact tables and dimension tables in your project?
Answers were Sorted based on User's Feedback
Answer / c h i t t i
Depend on project, for ex. mostly fact tables 1 or 2 and
dimensional tables infinity.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / nasa
In my project fact tables are 5 and dimension tables are 36
and team size is 12 and duration is 16 month and i developed nearly 80 to 990 reports in my project and my client is australia....
Is This Answer Correct ? | 3 Yes | 0 No |
Use of Text Source Variable in Report Studio?
-----------------What is Determination Model?
How to pass multiple values from picklist prompt to sub report filter?
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
Give me any example of semi and non additive measures?
What do you mean by drill across?
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?
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.
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt