How would you structure your Framework Manager Model? Would you structure into different layers?If you would structure what would be the layers like and what each of them would signify?

sandeep8000861

 Profile Answers by sandeep8000861 Questions by sandeep8000861

• Jun 18th, 2008

A model is normally structured into two layers/views. Database/ Physical view and Business/ Presentation view. These can be implemented using Namespaces.You import the metadata into Physical layer fro...

Answer Question  Select Best Answer

Given a scenario in which there are about 60 tables in Oracle and there needs to be created a Model in framework manager. What are the different pre-requisties that needs to be addressed in order to come to a conclusion regarding estimating the time to build the model?

praveenj6

 Profile Answers by praveenj6 Questions by praveenj6

• Feb 4th, 2008

There should be fact tables and dimension tables,join both by primary keys,resolve the loops,verify the model,create the packages and publish themit takes more than 1 month if the data is available

Answer Question  Select Best Answer

What are render variables?

roopacrn

 Profile Answers by roopacrn Questions by roopacrn

• Jun 2nd, 2009

Render Variable Specifies a variable based on which the object can be conditionally rendered. Ex:In the prompt page we have text box and value prompts .First we create value prompt with values text bo...

Answer Question  Select Best Answer

What is the maximum limit(no.) of values you can display in a value prompt?

Ajju B

 Profile Answers by Ajju B Questions by Ajju B

• Sep 12th, 2008

Maximum 5000 values displayed

Answer Question  Select Best Answer

Is it possible to create a drill through access to other report from a PDF report. If yes, how?

Riya

• Jun 7th, 2016

No. We cannot drill in the PDF. We can just export the data by pointing at each level/hierarchy.

Answer Question  Select Best Answer

viswanath.s

• Apr 24th, 2006

Hi, U can in do it in this way. first creat a list report in which u have a calculated item in the starting.Then creat a prompt page with a value prompt.In value prompt creat static choice of which u ...

Answer Question  Select Best Answer

shirin

 Profile Answers by shirin Questions by shirin

• Jan 26th, 2006

Setting up drill-through access from PowerPlay Web to ReportNet involves1. configuring Cognos Series 7 for drill-through access to ReportNet2. preparing the Transformer model and cube3. copying the se...

Answer Question  Select Best Answer

saiprasad

• Mar 21st, 2006

hi,procedure for providing security for query subject in frame work manager is:select querysubject -> in properties pane select ->security filters(click on edit)a specify data security wizard ap...

Answer Question  Select Best Answer

Viswanath.S

• Mar 15th, 2006

It has six (6) formats in report net. They are HTML, PDF, Excel 2000, Excel 2002, CSV, and XML format. We can see the types of formats in the report viewer on the right side .

Answer Question  Select Best Answer

Ravi k

• Apr 27th, 2006

Create a Query Subject, from the properties pane select externalise,there we have 4 options in that select IQD

Answer Question  Select Best Answer

shani

• May 31st, 2006

There isnt any need to copy the data before reporting on as long as the data is clean. But if the data is not clean it should be cleansed and so go for ETL process.Adv of reporting directly against th...

Answer Question  Select Best Answer

joys

• Jun 4th, 2006

Model is a representation of the metadata structures(imported from the soure datawarehouse).A model contains organized metadata objects(organizing depends on business needs).After the completion of a...

Answer Question  Select Best Answer

Pavan Reddy

• Oct 19th, 2006

Parameter maps are used to create the conditional Query subjects that allows for substitution at run-time. Parameter maps are Key Value phase, used for working with local languages. The default v...

Answer Question  Select Best Answer

arun

• Jun 29th, 2006

Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing

Answer Question  Select Best Answer

Raj

• Aug 16th, 2006

Stitch queries send two seperate queries to the data source and then merge them locally

Answer Question  Select Best Answer

Jo

• Jul 12th, 2006

You can create the IQD file from framework manager.This IQD file will be used by Transformer to create the cube.

Answer Question  Select Best Answer

ANAND BABU PATCHAVA

• Jul 19th, 2006

Tabular model: It is the basic list query. It contain the data items, filters and child tabular objects. Tabular SQL: We can write and edit our own SQL Tabular ref: It is a shortcut to another t...

Answer Question  Select Best Answer

pavanreddycognos

 Profile Answers by pavanreddycognos Questions by pavanreddycognos

• Nov 2nd, 2006

Hi Friends,Ambiguous Relationships : are defined with multiple query paths which leads to performance degradation and wrong results to be displayed on the report. These are results due to joins which ...

Answer Question  Select Best Answer

satya

• Oct 22nd, 2006

Database means any type of database   like Oracle, Db2, Taradata and etc?Data source means from where we r retrieving data it means data source may be database or cognos  EP series mapp...

Answer Question  Select Best Answer

cheran

• Sep 19th, 2006

Tabular Models have lot of advantages. Its like writing performance effective query where u will use sub queries. (eg:send the right data thru the sub query rather than giving a check for the full dat...

Answer Question  Select Best Answer