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

crishnathk

 Profile Answers by crishnathk Questions by crishnathk

• Dec 28th, 2006

hi jyotsna good morning,can u plz fwd some more examples regarding semi-additive & non-additive facts.cud u plz tell me what is granularity?here is my mailid:crishnathk@gmail.comthqharikrishna

jyothsna

• May 12th, 2006

Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. Non-Additive: Non-additive facts are facts that cannot be summed up...

Answer Question  Select Best Answer

swift_s

 Profile Answers by swift_s Questions by swift_s

• Aug 5th, 2009

Cognos PowerHouse (4GL, Web, Axiant) is an Application Development tool. It was Cognos' main bread&butter product prior to BI tools becoming so popular. It's hayday was in the 1990's as it was...

Andrei Mitiaev

• May 26th, 2006

Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity development environments for creating your data-driven business solutions faster,whether for ...

Answer Question  Select Best Answer

raghuram

• Dec 30th, 2006

Macro is a dynamic object which is used to substiute the values at query run time.prompt is dynamic conditon which select the value or enter the value at query run time

Pranuram

• Jul 25th, 2006

Macro-A macro is a set of instructions that can run applications.Example : A macro can open your catalog,select a report(say for instance) convert that to another format and export it to any specif...

Answer Question  Select Best Answer

Hello,I need to create schedule, based on day of week and time.Here is requirement for schedule: Report should run each business day at 08:00 A.M and return data for: ProcessStartTime (some data item) BETWEEN MON run - data from prior FRI 04:00 P.M. and today MON, 08:00 A.M. TUE run - data from prior MON 04:00 P.M. and today TUE, 08:00 A.M....

Neeraj Shukla

• Apr 5th, 2013

Create a radio button on the report and set its value Sch, create a filter on the report and set it like that

case when dayofweek is monday then (somedate between (currentdate-2 day)+8:00:00 and current date 4 hrs)
else somedate between (currentdate-1 Day)+8:00:00 and current date + 4 hrs)
end

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• Jul 23rd, 2011

Since you want data for last one week so put condition on the report to fetch data only for last week.

While creating schedule you can click check boxes for the required days.

let me know if you need any help.

Answer Question  Select Best Answer

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 23rd, 2009

Hierarchy defines the order of query items for report to report interactions [RRI]. Hierarchies are defined in query subject to support drill-down and drill-up functionalities.

Rpe

• Mar 26th, 2007

Ok, let's start with the definitions...hierarchyA description of the order of levels in a dimension. In Framework Manager, you define hierarchies in the query subject. levelA group of query items ...

Answer Question  Select Best Answer

thakklapelly anil

• Aug 30th, 2007

Hi Anand1)? Comparing with Reportnet, Cognos 8 have Analysis Studio, Metric Studio, Event Studio.2) The cube which is created in Cognos Powerplay Transformer can be published in Cognos 8 where as we ...

sranand123

 Profile Answers by sranand123 Questions by sranand123

• Mar 31st, 2007

HI Anand,Main difference between Cognos8 and CRN 1.1 are analsys studio , metric studio are added.

Answer Question  Select Best Answer

Internally what will happen in cognos if we run a report in report studio

Jay

• May 10th, 2014

Once the user runs the report, 1.The request is passed to the Web Server and gateways (CGI, ISAPI). The Cognos Gateway applies encryption to the information received, adds necessary environment vari...

Raghavendra

• Mar 13th, 2014

It will goto content store database to get metadata of required columns and data from specific database.

Answer Question  Select Best Answer

na__dim

 Profile Answers by na__dim Questions by na__dim

• Sep 25th, 2007

You will normally use scripting in Cognos when using Power Promts.

guru

• Jul 23rd, 2007

We can add JavaScript with the help of HTML item.

Answer Question  Select Best Answer

thakkalapellyanil

• Aug 30th, 2007

SCD means it explains?exactly how the changed data has been loaded into the target database.There are three types of SCDSCD1SCD2SCD3SCD1: It holds only current data.SCD2: It holds the current+histori...

rkiranbedi

• Mar 27th, 2007

Slowly changing dimension means these dimensions will change according to time,Ex: In Bank- a/c number, A/c name , address is there then if v change address then address will be a slowly changing dimension for that,It is of 3 typesType-IType-IIType-III.

Answer Question  Select Best Answer

adi

• Jun 17th, 2006

Visualizer is a representation of data cubes in a dashboard format. We can drill through to the ground level of a hierarchy as like in power play report but cannot add or remove fields dynamically.Cog...

jyothsna

• May 15th, 2006

Cognos Visualizer:Cognos Visualizer provides powerful visual analysis to communicate complex business dataquickly and intuitively. By going beyond simple pie or bar graphs, you can view and combinedat...

Answer Question  Select Best Answer

simmidear

 Profile Answers by simmidear Questions by simmidear

• Nov 12th, 2008

migrate all at a time from ReportNet to Cognos8(Frame work Manager, Reports, Cube)------------------------------------------------------------------------------------------In ReportnetOpen content sto...

zecar

 Profile Answers by zecar Questions by zecar

• Sep 19th, 2007

Are you talking abt cognos series 7 or only cognos reportnet?

Answer Question  Select Best Answer