How to change database option in
cognos10 content store as it has already fixed by db2.I need to change to msSQL
server.
1. Open the IBM Cognos Configuration
> 2. Go to Database Access, Select ContentStore then right click on it then Delete >
after that
> Select ContentManaget then right click
on it then Select New Source->Database->Name:xxxxx -> Type MSSQL
Server-> Click OK and give the User Name and Password.
There are many ways to
improve database performance. One of them being creating indexes on table
columns that are queried the most. Another is create table partitioning. A
whole lot else can be accomplished at the report level by fine tuning the query
or the filters created automatically by Cognos
Report
Studio.
Report
Studio.
Hi Techies, Need your
help for achieving this requirement. We have got a requirement to display a
report in a page which should display max 20 rows but if a report is having
totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5)
and the other two rows should appear in the next page. Similarly, If a report
is having 23 records then in the first page it should display 20 (divisible by
5) and on other page it should display 3 rows. Please advice!
Ans) Instead of doing
this at cognos level, try to do it at SQL level using rownum function. Take
the max of mod(rownum,5). then save the rownum value in a ?variable? and then
take all the records where rownum>? Variable?
level, try to do it at SQL level using rownum function. Take
the max of mod(rownum,5). then save the rownum value in a ?variable? and then
take all the records where rownum>? Variable?
Ans) 1.Drag a list
report 2.Add the query items you need for the list report 3.Add a Query
Calculation to the list report and name it as Running total,In the Expression
Definition Type in running-count([Query Item]) 4. Add a Query
Calculation to the list report and name it as Rows Display,In the Expression
definition type in floor([Running total]/17)
5. Go to the page Explorer and drag the page set to the page are 6. Change the Query of the page set to your list query 7. In the properties of the page set,click on the ellipses of sort and grouping 8.Drag the Row Display data item under grouping 9.Save and run the report.
5. Go to the page Explorer and drag the page set to the page are 6. Change the Query of the page set to your list query 7. In the properties of the page set,click on the ellipses of sort and grouping 8.Drag the Row Display data item under grouping 9.Save and run the report.
Hi , can any one tell how to convert
crosstab into list?What is the main use of unlocking the report?What is the
meaning of repeater & repeater table and when r they useful?Plz answer
these if any one knows?
Answered by: mani on: Apr
18th, 2012
there is no option for
converting a crosstab to list but we can do this by using cross tab space..at
the designing page it should look like a cross tab only but when u run the
report the report will shown to u in list format..u can do this by unlocking
and insert a cross tab space at the intersection point and in that add a text
item with the desired query item name....
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
as drill down and drill up.relationship is join the two tables (specifies cardinality 1-1,1-n
Query subject simply means a table...a
table contain columns...columns called as query items
Parameters generally
act as a filter to a report. Depending on the user selection the report is been
filtered and is provided to the user. They can be used to display what value
user has selected or what data the user wants to see.
Whereas Variables are
used to conditionally format or conditionally hide/show the object in the
report. They cant be used to filter the data in the report.
Asked By: Jagan | Asked
On: Oct 9th, 2005
Assuming 3 records per grouped item:1.
Group on employee2. Create a running count based on the skill field.3. Create 3
calculated columns based on the count field.Call them skill1, skill2, skill3:if
(count = 1) then (skill) else nullif (count = 2) then (skill) else nullif
(count = 3) then (skill) else...
I feel we can use the
tool functionality to achieve this as follows.
1. Create a list report having employee column
2. Create a cross tab - contains emp in row and skill in column
3. Provide Master Detail relationship between 'emp' of list & CT
4. Hide emp of CT and format appropriately
You can see the result as
1 abc and 2 def
1. Create a list report having employee column
2. Create a cross tab - contains emp in row and skill in column
3. Provide Master Detail relationship between 'emp' of list & CT
4. Hide emp of CT and format appropriately
You can see the result as
1 abc and 2 def
Handling Empty Reports
Specify Not to Render
a Page If It Does not Contain Data
You can specify not to render a report page if the page does not contain any data when the report is run.
Steps
1. In the report page, click a data container. > 2. In the Properties pane, click the select ancestor button and click the data
container type. > For example, if the data container is a list, click List.
> 3. Set the Render Page when Empty property to No.
4. Repeat steps 1 to 3 for all other data containers in the page as well as any table of contents > objects (p. 143). > When you run the report, if no data is produced in all data containers and table of contents objects > in a page, the page is not rendered. The page is not rendered even if the page contains other objects, >such as text items or images.
You can specify not to render a report page if the page does not contain any data when the report is run.
Steps
1. In the report page, click a data container. > 2. In the Properties
pane, click the select ancestor button and click the data
container type. > For example, if the data container is a list, click List.
> 3. Set the Render Page when Empty property to No.4. Repeat steps 1 to 3 for all other data containers in the page as well as any table of contents > objects (p. 143). > When you run the report, if no data is produced in all data containers and table of contents objects > in a page, the page is not rendered. The page is not rendered even if the page contains other objects, >such as text items or images.
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
Qube size is 2GB but in Cognos 10 qube
size may be increased to 2.5 GB or 3 GB
In Cognos 7 powerplay Cube support less
than 1 GB.
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.
prompt in filter with usage set to always - user need to supply a value to filter.
propmt in filter with usage set to optional - user need to supply a value for the filter / if user dont supply a value, filter will not be applied.
: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.
prompt in filter with usage set to always - user need to supply a value to filter.
propmt in filter with usage set to optional - user need to supply a value for the filter / if user dont supply a value, filter will not be applied.
Cardinality, a
component of relationship. defines how query subjects are related.
1..1 one and only one record from this side of the relationship
1..n one or more records from one side of the relationship
0..1 zero or at most one record from one side of the relationship
o..n zero or more records from one side of the relationship
Security types
package security - which defines access permissions to the package to author and run reports > object security- which allows to apply security to individual elements in the model. > data security- in which you apply security filters to restrict rows.
1..1 one and only one record from this side of the relationship
1..n one or more records from one side of the relationship
0..1 zero or at most one record from one side of the relationship
o..n zero or more records from one side of the relationship
Security
typespackage security - which defines access permissions to the package to author and run reports > object security- which allows to apply security to individual elements in the model. > data security- in which you apply security filters to restrict rows.
CAST is a complex
function that transforms one or more values from one data type into another.
.-<< , <<-----------. V | >>-CAST--(----source_expression +-- AS--DataType---------------->
>--+-------------------+--+----------------------+-------------->
'-CCSID--expression-' '-ENCODING--expression-'
>--+--------------------+--+---------------------+--)----------><
'-FORMAT--expression-' '-DEFAULT--expression-'
In practice, you cannot specify all of the above parameters at the same time. For example, CCSID and ENCODING parameters take effect only on string-to-string conversions, while FORMAT applies only to string-numeric and string-datetime conversions (in either direction).
into another..-<< , <<-----------. V | >>-CAST--(----source_expression +-- AS--DataType---------------->
>--+-------------------+--+----------------------+-------------->
'-CCSID--expression-' '-ENCODING--expression-'
>--+--------------------+--+---------------------+--)----------><
'-FORMAT--expression-' '-DEFAULT--expression-'
In practice, you cannot specify all of the above parameters at the same time. For example, CCSID and ENCODING parameters take effect only on string-to-string conversions, while FORMAT applies only to string-numeric and string-datetime conversions (in either direction).
What is the best way to convert Crystal Reports to
Cognos ?
Crystal Reports and Cognos are fundamentally two different technologies with very
different solutions. As per my knowledge, there are'nt any such ready tool to
do the conversion. Though Cognos offers a migration path and supports importing
a BO universe through a metadata-bridge and rebuild using a migrated metadata
layer, You will also need to have BO designer installed.
are fundamentally two different technologies with very
different solutions. As per my knowledge, there are'nt any such ready tool to
do the conversion. Though Cognos offers a migration path and supports importing
a BO universe through a metadata-bridge and rebuild using a migrated metadata
layer, You will also need to have BO designer installed.
Can we apply a filter on list of values in the
Value Prompt
yes,Its very simple to
achieve.When we create a prompt it will create a query for it separately(Prompt
query) other than the report main query.In that prompt query you can drag and
drop a filter and develop the filter expression like " country in
('India','Australia','South Africa') " (what ever countries you want to
see you can mention in the list).
Cognos Impromptu 6.0, Cognos Impromptu
7, Report net 1.1,Cognos 8.0, Cognos 8.1, Cognos 8.2, Cognos 8.3, 8.4 and
latest is cognos 10
Poor Performance of Cognos Reports
Data not in correct NF
> Loops in retriving data > Too many parameters
Pulling data from muliple sources
There can be many reasons otherwise the question needs to be more specific.
Pulling data from muliple sources
There can be many reasons otherwise the question needs to be more specific.
Solution:
1) Use the native SQL
from the Cognos report to do an explain plan
2) Check the sqlof the prompt page queries and use static values for prompts whenever possible. > 3) Validate the joins in Framework manager. > 4) Limit the number of rows displayed in an HTML report. > 5) Add filters to limit the amount of data returned.
2) Check the sqlof the prompt page queries and use static values for prompts whenever possible. > 3) Validate the joins in Framework manager. > 4) Limit the number of rows displayed in an HTML report. > 5) Add filters to limit the amount of data returned.
Yes. It is possible > Yes, We can
insert more than one measure in crosstab. Just drag and drop all the data items
like columns one after the other in the fact/measure area in crosstab.
Burst is; Sending information to people
when the information meets the criteria. i.e Balance to the the financial
controller.
Schedule; Time the production of reports.
Schedule; Time the production of reports.
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?
well, two things to
do.> 1- Use Static Choice for Prompt > 2- Apply render variable to render
the pages
Ans) 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 select the respective choice for the Page. I believe, that
can solve your problem.
, go to Page Properties, Set the
Render Variable and select the respective choice for the Page. I believe, that
can solve your problem.
Code
CASE WHEN
?Par_Text_Prompt? = 'Page 1' then 'P1'
?Par_Text_prompt? = 'Page 2' then 'P2'
.....
.....
END
Hi friends what is main difference
between content store and content manager?Give me one example for these related
?
Content Store: It is Cognos Database.
Content Manager: It is the application which controls the Content Store .
Content Manager: It is the application which controls the Content Store .
List: It shows detailed Information, We
can use any data item available.
CrossTab: It Shows summarized information, At least one measure must be included.
CrossTab: It Shows summarized information, At least one measure must be included.
cardinality tells the
relationship how many rows from one of the query subjects defined in the
relationship are expected to match a row in the query subject on the other side
of the relationship.
The cardinality tells Cognos 8 if one of the tables is expected to have more than one
matching record in the other (many-to-one relationships), or if a matching
record is not required at all (outer joins).
The cardinality tells Cognos
8 if one of the tables is expected to have more than one
matching record in the other (many-to-one relationships), or if a matching
record is not required at all (outer joins).
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.
WED run - data from prior TUE 04:00 P.M. and today WED 08:00 A.M.
THU run - data from prior WED 04:00 P.M. and today THU 08:00 A.M.
FRI run - data from prior THU 04:00 P.M. and today FRI 08:00 A.M.Answered by: shailendra32 on: Jul 23rd, 2011
,
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.
WED run - data from prior TUE 04:00 P.M. and today WED 08:00 A.M.
THU run - data from prior WED 04:00 P.M. and today THU 08:00 A.M.
FRI run - data from prior THU 04:00 P.M. and today FRI 08:00 A.M.Answered by: shailendra32 on: 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.
While creating schedule you can click check boxes for the required days.
Aggregate Function:
This function specifies what type of Aggregation to be applied on a data item.
The Aggregation can be of the types "Total", "Average",
"Minimum", "Maximum" etc.
Roll Up Aggregation: One above you have determined what type of aggregation you are applying on a data item e.g. Unit cost then here you can decide about the type of aggregation on the summarized values. In case of our Unit cost, if you have applied "Aggregate" choose here as "Maximum". Remember "The roll-up aggregation of any item is important only when you create the aggregation of 'Aggregate' type. Otherwise leave it as automatic.
Roll Up Aggregation: One above you have determined what type of aggregation you are applying on a data item e.g. Unit cost then here you can decide about the type of aggregation on the summarized values. In case of our Unit cost, if you have applied "Aggregate" choose here as "Maximum". Remember "The roll-up aggregation of any item is important only when you create the aggregation of 'Aggregate' type. Otherwise leave it as automatic.
What is the use of generated prompt?
Can u give complete information with scenario
Answered by: Cognos on:
Jul 17th, 2011
The prompt should be used when you are
not sure of which type of prompt best suits for requirement.
What
is meant by Junk Dimension? How do you perfom while running the report? Where
will you see the time of running report?
Size of the cube? What are the types of prompts in ReportNet?
What is macro and how it will be work? What is difference between Cognos and Cognos ReportNet? How do you create cube in ReportNet?
There are 10 facts are there.How will you connect all?
Size of the cube? What are the types of prompts in ReportNet?
What is macro and how it will be work? What is difference between Cognos and Cognos ReportNet? How do you create cube in ReportNet?
There are 10 facts are there.How will you connect all?
Junk dimension:
All the attributes which are not related to any other
dimension are put together to form a Junk dimension.
Types of Prompts: date prompt, time prompt, datetime prompt, interval prompt,
select and search prompt, tree prompt, generated prompt.
dimension are put together to form a Junk dimension.
Types of Prompts: date prompt, time prompt, datetime prompt, interval prompt,
select and search prompt, tree prompt, generated prompt.
Macro:
Marco is nothing but symbolic representation like #, (, en i.e is nothing
but shortly used things which will be done in framework manager to improve the
performance of the reports.
Cube can be created either by generating IQDS which will be source with in the
Transformer.
Different data sources available with in the transformer are
but shortly used things which will be done in framework manager to improve the
performance of the reports.
Cube can be created either by generating IQDS which will be source with in the
Transformer.
Different data sources available with in the transformer are
1) Cognos Report
2) Cognos Package 3) IQD 4) Delimited fixed text with column
titles
5) Delimited fixed text 6) Access table 7) Access query 8) Excel crosstab 9) Excel database
10) Powerhouse portable subfile 11) Fixed field text 12) Fixed field text with out crlf
5) Delimited fixed text 6) Access table 7) Access query 8) Excel crosstab 9) Excel database
10) Powerhouse portable subfile 11) Fixed field text 12) Fixed field text with out crlf
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 data
4.report is not able to oprm in excel
,cvs or xml
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 columns 4) Time/date filters do not match the format of the time/date data 5) Incorrect joins 6) Union queries do not have the same columns names
2) Data is not accurate in the report.3) Ambiguous columns 4) Time/date filters do not match the format of the time/date data 5) Incorrect joins 6) Union queries do not have the same columns names
What are the components of Cognos connection?
Cognos connection is the single point of entry to all of the report writing
tools. You can customize your pages and tabs. It contains cognos administration
allowing you to setup security, performance tuning, data sources and
import/export packages.
Cognos connection is the single point of entry to all of the report writing
tools. You can customize your pages and tabs. It contains cognos administration
allowing you to setup security, performance tuning, data sources and
import/export packages.
What are the components of query studio?
Query Studio is the ad-hoc reporting tool that allows you to create filters,
conditional formatting, custom groups, charts and summaries.
Query Studio is the ad-hoc reporting tool that allows you to create filters,
conditional formatting, custom groups, charts and summaries.
What are the components of report studio?
Report Studio allows you to create complex reports with custom prompt pages,
drill thru pages, master-detail joins, unions and also allows you to imbed java
script into the report.
Report Studio allows you to create complex reports with custom prompt pages,
drill thru pages, master-detail joins, unions and also allows you to imbed java
script into the report.
What are difference between master detailed relationship and
drill through
report?
A master-detail relationship allows you to create joins within the report. A
drill through report allows you to create a join to a separate report object.
report?
A master-detail relationship allows you to create joins within the report. A
drill through report allows you to create a join to a separate report object.
What are the steps to be taken care to
increase the executing of reports?
1)Use static values or
list of values in prompts when possible.
2) Perform calculations on the database side.
3) Limit the number of rows to be displayed at one time when possible.
4) Take off theauto summarization of the query when you're only displaying attributes.
5) Use the sql to do an explain plan on the query and tune the query.
2) Perform calculations on the database side.
3) Limit the number of rows to be displayed at one time when possible.
4) Take off theauto summarization of the query when you're only displaying attributes.
5) Use the sql to do an explain plan on the query and tune the query.
By applying the filtres, to eliminate
the un wanted data,by using local limited local processing,by using agregations
for facts(numerics).
To improve the performence of the report move all the calculations and filters from report level to frame work manager.
To improve the performence of the report move all the calculations and filters from report level to frame work manager.
A calculated measure is data item values
that have been transformed into one value.
A Measure folder is a folder used to stored calculated measures.
A Measure folder is a folder used to stored calculated measures.
Yes, Cognos 8.2 have
the capability of mouse over a data field like tooltip, changing colors when ever
mouse move to the dataitem.
I am going to describe the tooltip. For example:
Suppose we can take the list report with single item and take html item to the both sides of the item and put the below one and after that run it you can found in Cognos viewer the mouse over option.
<a title="Order number">Orderitem
I am going to describe the tooltip. For example:
Suppose we can take the list report with single item and take html item to the both sides of the item and put the below one and after that run it you can found in Cognos viewer the mouse over option.
<a title="Order number">Orderitem
What are the types of data containers
in cognos report studio?
List > Crosstab > Charts
> Repeater >
and also Nested Objects like
Block > Table > Conditional
Blocks
What are the advantages of tree prompt?
Why tree prompt was included in cognos 8?
A data driven prompt control that shows
hierarchical information and allows you to select one or more members. If you
take Order number, Product name, Return quantity the list will show products
that were returned more than 30 days after the order date.
We use a Tree Prompt when working with
dimensional data to prompt for hierarchial values.
A Tree prompt returns a set of members from with in a hierarchy.Add a tree prompt to let users filter the level of detail they want to report on in a single hierarchy.
A Tree prompt returns a set of members from with in a hierarchy.Add a tree prompt to let users filter the level of detail they want to report on in a single hierarchy.
GROUP is used to suppress the duplicate
values having one to many relations.
Associate is used to suppress the values having one to one relations.
Associate is used to suppress the values having one to one relations.
How will you provide security?How will
you provide row level security?
You can use session parameters to map a
data item to one of the ldap user values.depending on what you authentication
source is and if the necessary values are there. EX: Your ldap has employee #, Answered by: reply_me_web on: Sep 5th, 2008
Row Level Secuirty can be given in
Framework Manager using Parameter Map
In cognos we can create users,groups,roles by using third party
authentication likeCOGNOS ACCESS MANAGER, LDAP.After creating the users we can
provide the permission (like read,write,set policy,travers,execute)to users.
we can create users,groups,roles by using third party
authentication likeCOGNOS ACCESS MANAGER, LDAP.After creating the users we can
provide the permission (like read,write,set policy,travers,execute)to users.
A model is an set of metadata objects
organized for report authors according to the business models and rules. It is
an business presentation of the structure of data from one or more data
sources.
A package is an subset of query subjects and other metadata objects defined in the project.
A package is an subset of query subjects and other metadata objects defined in the project.
Slicing is a process in which you do an
equality selection of data from one or more dimension(perspective of facts how
it can be interpreted).
In dicing, you obtain a dataset in a range of selection.
In dicing, you obtain a dataset in a range of selection.
Create a report with
two lists. > Insert a single Data Item (Product Name) in list one.
Right click the Data Item (Product Name) in the list and go to Drill Through.
Add a new Drill Through, and choose the Bookmark tab. Set Source Type to Data Item Value.
Now insert some data items along with product line (Product Name, Quantity, Unit price e.t.c.) > Click on product name and create section. > Insert book mark by unlocking the report into the Product Name section. > Set the Bookmark property for Source Type to Data Item Value. > Set the Bookmark property for Data Item Value to Product Name. Note: These book marks will not work in HTML format as the page gets changed. Test it in PDF.
Right click the Data Item (Product Name) in the list and go to Drill Through.
Add a new Drill Through, and choose the Bookmark tab. Set Source Type to Data Item Value.
Now insert some data items along with product line (Product Name, Quantity, Unit price e.t.c.) > Click on product name and create section. > Insert book mark by unlocking the report into the Product Name section. > Set the Bookmark property for Source Type to Data Item Value. > Set the Bookmark property for Data Item Value to Product Name. Note: These book marks will not work in HTML format as the page gets changed. Test it in PDF.
By using HTML objects we can fulfill
some requirement which is not possible directly by Cognos in built components.
By using HTML object, We can insert multimedia file into report. At the run time we can see the file.
By using HTML object, We can insert multimedia file into report. At the run time we can see the file.
What is the usage and procedure to create a repeater object?
Repeater Object is
used to repeat data in a particular order. Its mainly used for mailing
lists. for example, say you want the Name, Address and telephone,
one below the other in a 3X3 table. You can drag in the repeater table, set 3X1
table for Name address and phone, and this information would get repeated in
the 3X3 table. Your output would have three names in the first table row
followed by the information.
,
one below the other in a 3X3 table. You can drag in the repeater table, set 3X1
table for Name address and phone, and this information would get repeated in
the 3X3 table. Your output would have three names in the first table row
followed by the information.
Enhance a report by adding conditional
formatting. For example, use conditional formatting to identify exceptional
data in a report.
With conditional formatting, you can hide and show objects, highlight data, add multiple layouts, create a multilingual report
With conditional formatting, you can hide and show objects, highlight data, add multiple layouts, create a multilingual report
By using date prompt . Can we schedule the report ?
Yes we can schedule a report to run on
specified date and time. We can even get the output as in email.
Refreshing the cube fetches the latest
data to the cube. Which can be used to extract the latest reports out of it.
Inorder to refresh the cube right click on the cube in powerplay transformer
you will get an option refresh cube click on it and its done.
Refreshing the cube means it just gets
the latest data and there is a option Refresh to do so.
A "junk" dimension is a
collection of random transactional codes, flags and/or text attributes that are
unrelated to any particular dimension
A junk dimension is a convenient
grouping of flags and indicators.
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.
In Cognos configuration cognos under
authentication the > Allow anonymous access should be false. > In cgi-bin properties (under
IIS) the enable anonymous > access should be false.
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.
We can access "Query Studio"
to create and view simple reports via cognos connection after
selecting the package that got imported from cognos content store. We can
now select Required Query Items from different Query Subjects to
generate ad-hoc reports.
Loop: Loop is a closed path (relation)
that exists among 3 (or) more tables. Loop gets created when "N"
tables have "N" joins.For example if we have '3' tables T1 T2 T3
the...
Answered by: rkiranbedi
on: Mar 2nd, 2007
Loop is a closed Path. it can be
exist b/w fact &dimensions, to resolve these we have to use shortcuts
Can you apply the master detailed relationship between query
studio report and report studio report? How?
Master detailed relationship from
query / Analysis studio report and Report Studio report can be created
only with the use of Package level drill through.
Render Variable: - Specify a variable
based on which object can be conditionally rendered.Style Variable: - Specify a
variable based on which object can be conditionally styled.
These management or all permissions
granted users are known as power users and without restricting or creating any
security for this level you need to grant all permission.
Yes this was the aproch in previous
version but from Cognos 8 specifically from 8.3 you have no data option
provided to handle missing values.
By Enabling the GOverner Settings we
can improve the performance.
The format that the column value uses.
For example, if Display Type is set to picture, MIME Type could be jpeg.
This property is for query items only.
Note: The MIME Type property is not used by SAP BW.
For example, if Display Type is set to picture, MIME Type could be jpeg.
This property is for query items only.
Note: The MIME Type property is not used by SAP BW.
Report security ? > How to apply
security on report?
For reports we apply the security in
Cognos connection.
Go to cc from the actions->setpropertiesicon->permissions->click the check box overide the permission and then set required properties to protect to your reports.
Go to cc from the actions->setpropertiesicon->permissions->click the check box overide the permission and then set required properties to protect to your reports.
Let me know if you have any another
solution.
Catalog contains metadata which is used
retrieved by warehouse database is called catalog.
Actually 4 types catalogs. They are Personal catalog Shared catalog Secured catalog Master Distributed catalog. > MDC is better one
Actually 4 types catalogs. They are Personal catalog Shared catalog Secured catalog Master Distributed catalog. > MDC is better one
Just an addition to the above
description's, Catalog also hold the relationships between the
tables selected from the database.
The major difference between query
conditions and document filters is that a condition is applied to the query and
limits the data retrieved from the database, whereas the filter is applied to
the data in the document to hide information and display only the information
that you want to appear
What are the unique advantage of having
3 explorer in cognos i.E 1) page explorer 2) query explorer 3)variable explorer
If there is no calculations and the
data is summerized, will you use materialized view? Give reason > they can
be used to summarize, precompute, replicate, and distribute data.> but if
there are no calculations needed and the summarization is already been done
then not sure if we need to use them
1. Getting the requirements for report
creation. (could be any functional document)2. Tables creation.3.
Working on the framework manager for data modelling 4. Starting report development according to the specifications. (can refer to any
technical document) 5. Testing of report (Writing test cases etc) 6. Delivering
the report 7. Working on change requests (if any) for the same.
according to the specifications. (can refer to any
technical document) 5. Testing of report (Writing test cases etc) 6. Delivering
the report 7. Working on change requests (if any) for the same.
Factless fact table
Explain with an example for factless fact table in real time project ?
Factless Fact Table: A fact table with
a key section but without a measure section. There are 2 types of
factless fact table: 1. Event Tracking Tables: A table that records an event.
A Fact table, without any measures is
called Factless Fact Table.For Ex.Survive Fact Table
Impromptu Query Definition - Database
metadata - Select the query subject items in FM that we want to export in the
form of an IQD and select the right option from the contextual menu
Let us assume that I have to create a
report whose output has 1 million rows. When I create the report and run it may
take several hours to show me the complete report. So can I limit the output to
just 100 rows to save time while testing the report? Thanks in advance.
You can limit data by applying
filter on some query item - for example if you have somany contract ids -
you can apply filter contract id -1234
In the run options set the data mode to
limited data.
What is the process of cognos testing
Can u give me small example of cognos testing?
Cognos unit testing includes1) Data
checking - you need to match against data exactly what you desired2) You need
to check the data format - eg check number of decimal places,date format,time
format 3...
Click on the Set Properties button of
the particular report. You get a lot of details of that report like report name
and description.
You can change the name of the report.
You can change the name of the report.
i guess by partitioning it in date,
month, year, hours, minute, second.
What do you record in unit test
documents?
in Unit testing we will check the
fontsize,Filters etc as per in the requirement document all these things are
recorded in the document.
Only in system testing using toad software will match the toad records with report output in cognos. > generally we are using toad software.it is a predefined tesing software
Only in system testing using toad software will match the toad records with report output in cognos. > generally we are using toad software.it is a predefined tesing software
Analysis Studio - an
application to analyze cubes and explore business data in a multidimensional
manner. Mainly used by business analysts.
• Metrics Studio - used for the scorecarding. The idea behind it is to put performance indicators next to the organization's key performance measures (red, orange, green status notation).
• Event Studio - a process (an agent) which runs in the background and monitors the data and reacts when ocurrs something which may be cause a problem in the future in the business. For instance, if quantity of product X on stock is less than a given value, event manager can send an email to the responsible person which will contain a warning with problem description and a cognos report attached.
• Metrics Studio - used for the scorecarding. The idea behind it is to put performance indicators next to the organization's key performance measures (red, orange, green status notation).
• Event Studio - a process (an agent) which runs in the background and monitors the data and reacts when ocurrs something which may be cause a problem in the future in the business. For instance, if quantity of product X on stock is less than a given value, event manager can send an email to the responsible person which will contain a warning with problem description and a cognos
report attached.
Prompts in framework manager
How can you create prompts in framework manager?
We dont actually create prompts in
FM.There is a property known as Prompt for each Query Item (field/column name).
You just set this property to the required prompt type.After the properties are
set, ... you publish the package.
In Report Studio, you just drag and drop this Query Item and define a filter with ?Query_Item?. You can set the Data Format for the Query Item here.
In Report Studio, you just drag and drop this Query Item and define a filter with ?Query_Item?. You can set the Data Format for the Query Item here.
Repeater table What is the repeater
tablethanks,
Repeaters are tables in which you can
insert items that are repeated when you run the report. For example, use
repeaters to create mailing labels. To build a repeater, drop the items you
want in the repeater object. Then modify the
properties of
the repeater to obtain the results you want. For example, you can specify how many repeater frames appear per page by typing values in the Across and Down properties.
the repeater to obtain the results you want. For example, you can specify how many repeater frames appear per page by typing values in the Across and Down properties.
Fact less fact table
What is the fact less fact table? Why we use this table?
A fact table
without measure is called a fact less fact table
for negative analysis report we use this fact less fact table
for negative analysis report we use this fact less fact table
we can use 1.incremental updates,2.use multiple
data sources or 3.partition
your cube using auto-patition, the size of the cube but runtime performance
will increase drastically.
4.check power cube status and 5.perform test cube .Refer step by step transformer guide for more details.
4.check power cube status and 5.perform test cube .Refer step by step transformer guide for more details.
Please explain me how to import two
data sources into framework manager?Can anyone tell me what is role of reporter
writer in cognos?
We can import two data sources to
Framework Manager in the Run Metadata Wizard.
Go to Run Metadata Wizard-->Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it.
Go to Run Metadata Wizard-->Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it.
Static choice Could u explain
briefly what is static choice?
Static Choice is set of choice you
provide to user for selection. These choices are manually entered in the field.
E.g for value prompt when you select Radio GUI then you give choices to your
users by manually entering the choices by selecting Static Choice property and
clicking add new.
In report level:
1)you can reduce the calculation and condetions in the report > 2) you can limit the cut copy phaste operations for user's > 3) you can limit access no of report's at peek time you can improve performence at report level
in model:
1)you can remove loop's at that time you can improve performence at model level
2)use indexces you can improve performance
1)you can reduce the calculation and condetions in the report > 2) you can limit the cut copy phaste operations for user's > 3) you can limit access no of report's at peek time you can improve performence at report level
in model:
1)you can remove loop's at that time you can improve performence at model level
2)use indexces you can improve performance
Level span is used to eliminate
duplictes in data, in cognos it is used repeat grouped item.using levelspan we
can see the grouped data group by group.For example, when country and city are
both group...
Answered by: venu on: Sep
16th, 2007
Level Span is used to eliminate
duplicates in a report which contains columns with one-one relationships.
Usually we use grouping to eliminate duplicates when there is one to many
relation. But if there is one-one relationship and still there are duplicates,
then we have to level span.
By using Framework Manager we can create
IQD files ,By using IQD files we can creat cubes in powerplay
Usage property identifies the intended
use for the data represented by each query item and it determines the
aggregation rules of query items and calculations.
The different usage property settings are Identifier,Fact,Attribute, and Unknown.
The different usage property settings are Identifier,Fact,Attribute, and Unknown.
One possibility would be to review the
data available and use prompts if possible. This way, you could limit the
amount of data being retrieved and thus allow for a faster response time.
The syntax is as follows: LOOKUP (name)
in (value1 --> value2) default (name)Name: the name of your columnvalue1:
value you would like to be replacedvalue2: value you would like to replace it
withd...
Answered by: narender on:
Jul 23rd, 2007
By using parameter map
Asked By: chim | Asked
On: Mar 15th, 2006
1. In Cognos Connection, Go to Public Folders or My
Folders, click the schedule button for the report you want to schedule.
2. Under frequency, select how often you want the schedule to run.
3. Under Start, select the date and time you want the schedule to start.
4. Under End, select the date and time you want to end the schedule.
5. Under Formats, click the format you want to run the output.
6. Under Languages, select the languages to select different languages.
7. Under Delivery, choose any one delivery method.
8. If you want to be prompted, under Prompt values,select the Prompt for Values checkbox.
9. Click Ok.
Connection, Go to Public Folders or My
Folders, click the schedule button for the report you want to schedule.2. Under frequency, select how often you want the schedule to run.
3. Under Start, select the date and time you want the schedule to start.
4. Under End, select the date and time you want to end the schedule.
5. Under Formats, click the format you want to run the output.
6. Under Languages, select the languages to select different languages.
7. Under Delivery, choose any one delivery method.
8. If you want to be prompted, under Prompt values,select the Prompt for Values checkbox.
9. Click Ok.
Snapshot is the permanent local copy of
the data in your report.
You have missed one more important
point. > For incrimental update cube additionally we need to create hot
files and frequently update the cube and over write the old hot files with
latest hotfiles and then update the cube.
--->
Select Impromptu Admin. --->
Catalog ----> Folders
---...
Answered by: rkiranbedi
on: Apr 13th, 2007
Open Impromptu Administrator -> Catalog
-> Folders option
Select the
column you want to > Click the Edit button, From Left Pane Select Particular Column which you wants to Rename Drag that into Right Pane then >Select that Column and Click on Rename Button then Change the name.
column you want to > Click the Edit button, From Left Pane Select Particular Column which you wants to Rename Drag that into Right Pane then >Select that Column and Click on Rename Button then Change the name.
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.
They are 1. Database which contains all the data
2. Hot file which is meant as local database. this also contains Meta data.
Actually there is no limitations for
fact and dimensions tables. That depends upon the data and the project. Normally
we have 60 dimensions and 17 fact tables.
Yes. You can do this by following the
steps below:1. Configure Access Manager runtime on your desktop using
"Access Manager - Configuration Wizard"
2. Update Catalog
properties in Impromptu to use Access Manager by specifying the namespace.
3. Finally, use Access Manager memberships to control the Table/Folder access in Catalog using the menu option "User Profiles" or use the Access Manager variables that are available in the Expression Editor of Impromptu.
3. Finally, use Access Manager memberships to control the Table/Folder access in Catalog using the menu option "User Profiles" or use the Access Manager variables that are available in the Expression Editor of Impromptu.
to day function is used for represent
the to day date(sys date) while now function is sys time
CAMID stands for Cognos Access Manager
ID, and it represents an internal search path to the recipients. Specify search
paths when you want to save burst reports in a directory.
Cognos uses KERBORES security model. It
was the model which was found in 1980.
by using third party authentication.
Hi,You can change database connections
in Catalog level.Catalog-->Tables-->retrieve table.You will see radio
button for Atached dB.
use the list box and
select a desirable DB if it is attached toCognos.
or else create DB connecting by selecting the following option
Catalog-->databases-->ODBC-->New database-->Create a new connection.
.
or else create DB connecting by selecting the following optionCatalog-->databases-->ODBC-->New database-->Create a new connection.
Answered by: Mohan Potla
on: Jun 14th, 2007
Set of similar cubes built by
Transformer. Each cube group relates to a single level in one dimension of the
model. Each member of the group is targeted at one of the categories in the
level.
We can create as many
as it support.
We can navigate between them using CubeGroup
Which consist all together.
We can navigate between them using CubeGroup
Which consist all together.
We can provide border for that chats
you select chat and select properties you will set there box type there.
An associate is used to make one to one
relationship. but before associate u must have to apply group. Ex:
ordeno,orderDate,Productname is there apply group on orderno and apply
associate on order date then it will give one to one relationship between
orderno,order Date.
A datawarehouse is
collection of "data marts". A data mart satisfies one aspect of your business.
Data mart consist of "Dimensions" and "Facts"
Dimension are things like Location , Time etc.
Facts are numeric values (KPI) > Dimension "describe" a fact value.
. Data mart consist of "Dimensions" and "Facts"
Dimension are things like Location , Time etc.
Facts are numeric values (KPI) > Dimension "describe" a fact value.
Cube data could be quickly evaluated
using powerplay for windows
Use transformer to build Time dimension
in a model and create multiple cubes using the same model.
Transformer supports a wide range of
local data sources, including
, including
Impromptu query definition files
(.iqd), which can query local or server-based databases
delimited ASCII files (.asc) and
comma-separated variable files (.csv)
fixed-field text files
local databases, including Microsoft
Access, which can specify SQL queries against local or
server-based databases, Clipper, dBase,
FoxPro, and Paradox
PowerHouse portable subfiles
spreadsheet crosstabs
and databases, including Excel and Lotus 1-2-3
A: 3MB
refreshing a cube means getting the
latest records fron content store.we have one option refresh to do that.
Conditional Blocks adds an empty block
that you can use for conditional formatting.You can hide and show objects in a
report based on a condition you define.
Type In prompt is User entered Values,
but Pick List Prompt is User selected Values
Yes, there is some
limitation of generating the report in CSV.The maximum no. of rows is 65000 and
columns is 256. if the data exist more then 5MB. then the report would take
long time to excute and some time it wont.
at package level we can provide
security, by selecting and unselecting the query subjects(tables).we can
also hide the tables.
at report level save ur report in
personal folder.
By using ACESS MANAGER we can set
security to users.
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
in power play transformer
on toolbar select RUN menu .in RUN menu there is one option that isTEST BUILD
In FM right click on the Namesapace in
which you want the stored procedure to be imported...Select
Create->QuerySubject....
New Query subject window appears...
Select the third option "Stored Procedure" -->Click Ok...New
Querysubject Wizard appears in that...Select the Datasource...-->Next
In the select stored procedure window
select the appropriate stored procedure and click "Finish"...Define
the properties for the Procedure.....That's it and you can view the procedure
as a query subject inside your namespace.
|
Package level
|
Object level
|
Data level
|
|
Expan the namespace,
R click on package > Click on Edit Package Package Access window appears, Remove "All users" from it Click Adds, select Cognos Select "Report Administrator", OK it, save the package in Framework Manager (FM) Publish the package |
Expan the namespace,
R click on a table > Click on "Specify Object Security" On "specify Object Security" window, click on ADD On "select users and group" dialog box, select Cognos Select Report Administrator & Consumers Click Add In new window, under allow Report Administrator, deny consumer Now R click on namespaces, click on " Specift Object Security "Here allow both consumers & Report Admni Right click on packages, "Explore package " window opens Select "Object security tab" appears You will be allowed see who is allowed and who is not |
Right click on a
table
Select query subject, select "specify security filter" "specify data security" dialog box appear click on ADD select cognos select consumers, Ok it click the first row, click on insert In Filters folder, select the appropriate filter save the package and publish it |
1 Start Cognos Impromptu Administrator.
2.From the File menu select Catalog
-> New.
3. In the File name text box, type the
desired name of the catalog. In the Description text box you can add a
description but this is not mandatory.
4. In the Database dropdown select the database that you
want to use or click on the "Databases" button select an ODBC
connection that you want to use i.e. DB2, Oracle etc. and click the "New
Database" button.
dropdown select the database that you
want to use or click on the "Databases" button select an ODBC
connection that you want to use i.e. DB2, Oracle etc. and click the "New
Database" button.
5. Click "Ok" and enter the
database logon and password. Click "OK" again. You should
see a database icon in the lower left of you screen without a red X over it.
6. Select the tables that you want to
use my highlighting them on the left side and using the "Add"
arrow key to add them to the "Catalog Tables" side. Click
"Ok" when your finished.
7. To create Joins in your tables
select the table under the "Join path" window and the table that you
want to join it to from the "Available tables" window.
8. Click "Add" and choose the
fields to join the tables, click the "Add link" button to create your
join.
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.
Cognos script editor : We can write cognos
macros or programs in this tool and can fine tune or process some execution.
script editor : We can write cognos
macros or programs in this tool and can fine tune or process some execution.
Data source for defining a
catalog may be any database.Whether it may be a relational database(like
Oracle,sql server, DB2,Tera data etc)
You can create measure once you import
all the data into the data source.You can create measures and dimensions by
draging the required source from datasource into dimension map and measure
tab.(need to find scope of measures for all the dimensions)
powerplayFrom format menu-->title,
header & footer-->title-->insert report filename
Cognos 6.6 7.0,7.3(PowerPlay,
Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by
Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet.
there are many other tools but these are the main.
0 Comments