Can we apply a filter on list of values in the value prompt
Can someone tell me whether can we apply filter on list of values in the 'value prompt' e.G. I have a value prompt (named city) and the prompt is holding around 2000 cities but I want to apply a filter on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible...
How can I create a dynamic column name in cognos
1.Create a calculated column which contains the information that the header is to contain, such as "report for year 1999" (concatenated text and date to string sub string extraction). 2.Highlight the report, and then right-click. 3.Select properties, and then click the headers/footers tab. 4.Clear the...
Answered by: moissi
Answered On : Nov 3rd, 20071. add a data item to the query(the query on which the report is based)
2. define an expression which u want to use for the dynamic column label
3. from the report page click on the column label
4. from properties pane look for "column label" the default would be "data item label/name" change that to "data item value"
5. in the same pane change the "data item" property to have the data item that u created for the column label.
Two ways to used in dynamic columns in Report Studio
1.Query Calculation
2.DataItem
Mgani, How we can create the column headers dynamically using parameter maps. Here is what I am facing, in the data table we have following columns Id, Fact Period And in a Translation Table I have...
What is the difference between burst and schedule options ?
Burst: you can send the data in n no of recipients through emails burst option types is: automatic email addresses ...
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.
Complicated schedule for cognos report
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,...
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
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.
If you have a report with list and cross tab in the same page. How do yourestrict one user can see only the list and the other user can see both?
Report Studio is A Professional studio
You have used the conditional block with render variable concept.
How to convert crosstab into list?
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?Best regardspaddu
It is not Possible any studios in congnos convert to crosstab into list is not possible but list is converted into crosstab its possible. and also list is converted into Repeater table.
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 wil...
What is the difference between list and crosstab?
List: Detailed information
Crosstab: Summarized information
List: It shows detailed Information, We can use any data item available.
CrossTab: It Shows summarized information, At least one measure must be included.
Can we use more than one measure in crosstab ?
Yes
Yes. It is possible
Query subject is nothing but a Table
A query subject is like a select statements which contain certain columns from the database. It is not exactly the replica of the columns in the database so you cannot say it as the database table. It is a view of the database table containing few or all of its columns.
What exactly cognos 4gl? What are the resources of cognos 4gl?
Cognos 4GL is a 4th generation language by IBM, which is used for reporting in Cognos, but these days it is outdated and not much organisations are using it.
It contains 4 tool:
QTP
QUIZ
QDESIGN
QUICK
Explain aggregate function and roll up aggregate funtion in cognos?
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...
Where do you perform scheduling in bursting reports?
Cognos connection
Performance in executing reports.
What are the steps to be taken care to increase the executing of reports?
set the report hints,
limit the maximum execution time,
limit the maximum table retrieving,
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 theĀ auto...
What is the use of prompts in framework manager?
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...
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...
Change of database name in cognos10 content store
How to change database option in cognos10 content store as it has already fixed by db2.I need to change to msSQL server.
I created value prompt, when I select Few values in prompt these values showing in report header between (,)s.
I need (-) in between two values.
Could you please suggest me.
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.
How to improve performance from database side..
What to do at database side to improve performance? what is performance tuning?
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 accomp...
What is dash board give me example?
in simple understandle way ,dashboard is a ,to view number of reports in a single page.
Its simply a collection of reports.Suppose you want some data to be displayed as graph and some you think can be better understood through a pie-chart .In this case you can choose to create a dashboar...
Restricted rows display to the report page which should divisible by 5
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...
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...
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?
What is complex report ? Give me an example?
if we apply filters,prompts,calculations in a report then that is called Complex report.
Difference between scope and relationship?
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
1)Open the value prompt query
2)Drag a filter from tool box into detailed filter
3)Write the filter condition like country in (India,Japan,china,- - - - - - - )
that's it
I am sure your table has other high-level data item that you can group cities into like region, district or countries. You can cascade from them to limit your cities.