What is procedure of deployment in Cognos installation?

Jimmy Zorald

 Profile Answers by Jimmy Zorald Questions by Jimmy Zorald

• Nov 20th, 2011

After completing the preceding configuration procedures, you can deploy IBM Cognos Now! on the application server. Start the IBM WebSphere application server, if it is not currently running, and open...

Namrata Gade

• Aug 13th, 2011

1. Copy contents of attached notepad file i.e. XML code of the report. 2. Launch Report studio, select package Package Name. 3. Open Report studio as a blank report. 4. In Report Studio, go to Tools -...

Answer Question  Select Best Answer

Hi ,suppose if a report contains n pages like page1,page2, upto pagen, in a textbox prompt when we enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer?

Chandra Kiran

• Aug 17th, 2011

You can use the Render Variable method. Make a String Variable and place the CASE WHEN Statement with the Parameter values. In the Page Explorer, go to Page Properties, Set the Render Variable and s...

buddy

• Aug 2nd, 2011

Well, two things to do.
1- Use Static Choice for Prompt
2- Apply render variable to render the pages

Answer Question  Select Best Answer

Devi Archana

 Profile Answers by Devi Archana Questions by Devi Archana

• Jan 26th, 2012

A few of the date fields have a time stamp attached to them... time stamp is nothing but the time in the format of HH:MM:SS:NN.... for example.. i have an update today at 9:30pm then time stamp would be 26 January 2012 21:30:15:11

sasikalyan

• Dec 26th, 2011

These are called delta attributes. You could define only one delta attribute while creating generic delta. 1. Time stamp - The field is a DEC15 field which always contains the time stamp of the last ...

Answer Question  Select Best Answer

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

1.Choose Run with Options 2.Click on advanced options link3.Click run in the background (Now) 4.Change Format option to desired Option (Excel, PDF, HTML, CSV, etc.) 5.Select Delivery Option of Send th...

Joe

• Mar 13th, 2013

Cognos connection

Answer Question  Select Best Answer

Ravinaga

• Jan 18th, 2013

Generally cube size is 2GB only but if we want to increase the cube size then we need to go to partition scenario. For exp: I am creating one cube with year basis that means that year cube having 2 G...

Aruna2008

 Profile Answers by Aruna2008 Questions by Aruna2008

• Dec 10th, 2011

Use of Prompt in Framework Manager: Filter on query subject - to restrict the rows that are returned by filtering out the unwanted data by creating one or more embedded filters for query subject. pr...

Answer Question  Select Best Answer

cognos_anu

• Jun 21st, 2017

Scope relationship exists between Regular Dimension & Measure Dimension.
It determines the level at which facts/measures are available for reporting.
We can view, edit, create scope relationships.
They are automatically created based on the joins between tables of Modelling layer.

shyam

• Mar 17th, 2012

Scope is used to join the regular dimensions and measure dimensions to perform multi dimensional analysis such
as drill down and drill up.

relationship is join the two tables (specifies cardinality 1-1,1-n

Answer Question  Select Best Answer

Sandy

• Sep 24th, 2013

Different aggregate functions are used to perform different operations on the column of the table. Aggregate functions are MAX,MIN,SUM,AVG and COUNT. It makes the calculation more easier.

Prakatta

 Profile Answers by Prakatta Questions by Prakatta

• Mar 21st, 2013

Aggregate Function specifies what type of aggregation to be applied on a data item like Total ,Average, Min etc., The roll-up aggregation of any item is important only when you create the aggregatio...

Answer Question  Select Best Answer

Hi All,
There is a scenario.There should be one prompt page having choice to choose between:
->List
->Cross tab
According to the choice selected, the page generates either List or Cross tab.
Please suggest the solution with steps.
Thanks

Samir

• Nov 19th, 2013

1. Create the List and Cross tab reports with required data. 2. Drag and drop a value prompt to the prompt page. 3. Name the parameter as selection, then click on finish. 4. High light the value promp...

santosh

• Oct 9th, 2013

In your first page Drop your list and CrossTab Insertable objects fill ur data in those. Then create a Prompt page where in drop Value Prompt Object with paramter1 just click finish In the properties...

Answer Question  Select Best Answer

There is a scenario: Display the list data in the order-first even position rows and then odd position rows.....Can anyone help on this issue..

Soumyadeb Halder

• Feb 17th, 2014

Suppose your table is "employee" and column name is "empid" . Now you want a list which contains EVEN empids first and then ODD empids. Your query will be like below, Select empid from employee orde...

Gajendra kumar

• Nov 28th, 2013

First check based on which column the odd and even value should come. For example in a list EVEN EMP_ID should display first and than ODD EMP_ID. Now drag this column to query subject. Create an...

Answer Question  Select Best Answer

What is Scope in report studio?
Can you write a YTD FUnction?
What is global Variable?

Lakshmikar

• Aug 17th, 2016

Extract(date,YYYYMMDD) from dual;

lakshmikar

• Aug 10th, 2016

Extract(date,yyyymmdd)from dual;

Answer Question  Select Best Answer

How restrict the user to add a new data item in a container (List) in Report Studio?

Khalid Mehmood Awan

• Jul 25th, 2017

In that case, the report will be a snapshot report.

Reddy25

• Oct 25th, 2016

In Report properties, Goto Permissions page and select the user/group/role in which the user belongs to and deny the write permission.

Answer Question  Select Best Answer

NagaShilpaV

 Profile Answers by NagaShilpaV Questions by NagaShilpaV

• May 20th, 2009

Using Current_Date function, you will get the current date. Then use the extract function to extract day, month and year. Then hardcode the filter in the query for day and year.

raju

• Nov 23rd, 2005

You have a function called 'extract' in cognos.Ex:- extract(month,the dte field). by giving like this you will get month. so you can keep a filter to restrict the rows only for october.

Answer Question  Select Best Answer

sithalakshmi

• Apr 24th, 2007

Can you explain in breif means to say that the exact way how to drill down to each cube

rkiranbedi

• Apr 16th, 2007

HiWe can create as many as it support.We can navigate between them using CubeGroupWhich consist all together.

Answer Question  Select Best Answer

kiran kumar

• Nov 18th, 2006

In power play transformer   on toolbar select RUN menu .in RUN menu there is one option that is TEST BUILD

Anindita Ghosh

• Apr 5th, 2006

 In cognos report net by the validate report option a report can be tested. If there will be any error, it will specify the the error, unless it will give message  -'report specification is valid'.

Answer Question  Select Best Answer

bonniewade1

 Profile Answers by bonniewade1 Questions by bonniewade1

• Jan 14th, 2011

1) Report performance - Prompt page takes a long time to load or the report takes a long time to generate.2) Data is not accurate in the report.3) Ambiguous columns4) Time/date filters do not match ...

Anindita Ghosh

• Apr 5th, 2006

the most common problems are -1.No Data Appears in the Report (to remove this check data source or package)2.Unexpected or incorrect values appears in reports , may be report is running with limited d...

Answer Question  Select Best Answer

vipvats

 Profile Answers by vipvats Questions by vipvats

• Oct 13th, 2007

Model is a way to represent the architechtural structure of the Data warehouse. It consists of dimensions, Data sources, Measures. To create a model following steps should be followed 1. From the File...

Anindita Ghosh

• Apr 5th, 2006

Model Definition Model in PowerPlay Transformer is combiantion of five windows- Dimension Map,Data Source, Measures,Power cube,Sign On. Models specify the data sources and then defining the dimensions...

Answer Question  Select Best Answer

rkiranbedi

• Mar 2nd, 2007

Work with Source Data Transformer supports a wide range of local data sources, including• Impromptu query definition files (.iqd), which can query local or server-based databases• delimited ...

Anindita Ghosh

• Apr 5th, 2006

Work with Source DataTransformer supports a wide range of local data sources, including? Impromptu query definition files (.iqd), which can query local or server-based databases? delimited ASCII files...

Answer Question  Select Best Answer

ranganadh

• May 31st, 2007

From which package u want to select and then go to select the template. According to ur documents select & add?query items and if any conditional and filters u have add to ur report. After complete your report u have to test the report.

Zoro

 Profile Answers by Zoro Questions by Zoro

• Mar 27th, 2006

Before creating any report in report net make sure you are have the planning information you need.Creating a report involves following steps:Specifying a packageChoose a package through cognos connect...

Answer Question  Select Best Answer

prudhvi.g

 Profile Answers by prudhvi.g Questions by prudhvi.g

• Sep 3rd, 2007

We've 2 ways to import data into a catalog.They are 1. Database which contains all the data               2. Hot file which is meant as local database. this also contains Meta data.

Jyothsna

• May 15th, 2006

One through Database optionother one though hotfile option

Answer Question  Select Best Answer

swift_s

 Profile Answers by swift_s Questions by swift_s

• Aug 5th, 2009

The following document will walk through all steps needed in setting up drill through from PPES to IWR.Create 3 Folders in Windows Explorer1. On C: create a folder called C:DT2. In C:DT create another...

panini

• Apr 16th, 2006

goto tranformer,build the cuberight click on the cube and open propertiesgo to drill through tab and select your report from that browse option

Answer Question  Select Best Answer