Hi Everyone, Can you please tell me what is the difference between ForEach and ForAll (In BO Reporter), and give examples of when they are needed ?. Much appreciated !.Thanks in advance,Veronica

mvm2002_2002

 Profile Answers by mvm2002_2002 Questions by mvm2002_2002

• Dec 7th, 2007

For each The For Each context operator allows you to add dimensions to the current default input context. For example, if a table contains the dimension [year] and [Quarter] and the measure [reven...

Answer Question  Select Best Answer

sreya_1234

 Profile Answers by sreya_1234 Questions by sreya_1234

• Dec 6th, 2007

Go to insert -> special field -> date and time -> last refresh,  now click below the report area - you will get the date of the last refresh on that particular report.

Answer Question  Select Best Answer

zingara

 Profile Answers by zingara Questions by zingara

• Dec 1st, 2007

Create a seperate folder and dump all the reports to be hidden in it and hide the folder via CMC

Answer Question  Select Best Answer

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function.

sheriey

 Profile Answers by sheriey Questions by sheriey

• Nov 29th, 2007

The @Aggregate_Aware function allows an object to take advantage of tablescontaining summary data in the database. If your database contains summarytables and you are running queries that return aggre...

shilps.verma

• Nov 24th, 2007

Lets understand the use of Aggregation first with examples.Information is stored in the datawarehouse in the summarised form.Instead of recording the date and time each time a certain product is sold,...

Answer Question  Select Best Answer

sheriey

 Profile Answers by sheriey Questions by sheriey

• Nov 29th, 2007

You can do in Webi also. This is not the proper way but it is just a work around. Just make the backgroung color and text color white and minimize the width. you will only see a little gap in the report

Amit Sachan

• Nov 21st, 2007

We can hide the coloumn from the report with out formatting.when ever you are making the report the total columns comes in dataprovider in form of select query. those columns also appear in slice and ...

Answer Question  Select Best Answer

rama krishna reddy

• Nov 27th, 2007

We can combine the queries like UNION,INTERSECT AND MINUS.We can do this in Business Objects Click Edit Data Provider-->Data Provider Window Opens in that click Combined Tab.

Answer Question  Select Best Answer

MuthuKumar Sankar

• Nov 27th, 2007

Off Peak time is nothing but a duration which is used by BCA. BCA can reduce the traffic on the network by running the reports at off peak times.

Answer Question  Select Best Answer

sarangoun

 Profile Answers by sarangoun Questions by sarangoun

• Nov 23rd, 2007

Hi All Cubes is nothing but, is an data processing unit it's composed of Fact & Dimention Datas From DWH.

vaibhavg

• Apr 25th, 2007

Micro -cube is a local structure in bo that stores the result of your query? before generating report..

Answer Question  Select Best Answer

Amit Sachan

• Nov 21st, 2007

Suppose you want subtotal of amounts vendor wise in your report then insert the break into vendors then take sum for amounts field. It will automatically calculate the sub total of amounts vendor wise and also show the whole total of all vendors in last page of report.Cheers,Amit Sachan

Answer Question  Select Best Answer

Amit Sachan

• Nov 21st, 2007

Hi,this facility is not available in BO version 6.5 but if you want to do then you will have to make macro based report and you can write the exporting code behind the macro.cheers,Amit Sachan 

nishamakhija21

 Profile Answers by nishamakhija21 Questions by nishamakhija21

• Oct 23rd, 2007

You can not export in word. its not supported by BOXIR2.

Answer Question  Select Best Answer

when we use 2 data providers, and each data provider contains different universe,when we merge these two universes in a report with some common dimension, then what will be the result of the report with that merging dimension and one measure from one universe and one dimension from other universe?Eg: Universe1 and Universe2 say merging dimension is d1 and measure m1 from universe1 and...

Prashant Purohit

• Nov 19th, 2007

Hey in such case you can only use dimensions from one data provider in the report except the dimensions which are involved in merging. Meraged dimension can be used from any of the data provider. Measures from both data providers can be used in single report. 

Answer Question  Select Best Answer

sarangoun

 Profile Answers by sarangoun Questions by sarangoun

• Nov 19th, 2007

 HAI I AM SARAVANANFile watcher is using in BCA. File watcher using  4 options  using reports  scheduling in BCA.1) Delete the file each time the task starts2) Never delete th...

Answer Question  Select Best Answer

what is it used and what are the steps to follow BCA??

sarangoun

 Profile Answers by sarangoun Questions by sarangoun

• Nov 19th, 2007

HAI I AM SARAVANAN    BCA is a document sceduler that allows you to publish the finished results in a number of ways ,BCA is a software product to process and distribute documents autom...

swapna

• Nov 13th, 2007

A Business Objects application that allows users to automatically process and publish documents using either the repository, intranet, extranet or over the web. Broadcast Agent consists of four components: Scheduler, Broadcast AgentConsole, BusinessObjects Services Administrator and BOManager

Answer Question  Select Best Answer

sreya_1234

 Profile Answers by sreya_1234 Questions by sreya_1234

• Nov 12th, 2007

We can identify the aggregate awareness objects from various tables.for eg:- Revenue for a particular product in a year. for this aggregation as follows:AAYear.Revenue - this is the highest level of a...

Answer Question  Select Best Answer

sreya_1234

 Profile Answers by sreya_1234 Questions by sreya_1234

• Nov 12th, 2007

Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval. When you set up index awareness in Designer you tell Designer which database columns are primary and foreign keys. This can have a dramatic effect on query performance.

Answer Question  Select Best Answer

sreya_1234

 Profile Answers by sreya_1234 Questions by sreya_1234

• Nov 12th, 2007

BO main key is the location of the repository where it stored.It stores the address (path) of the repository.

Answer Question  Select Best Answer

jaya

• Nov 12th, 2007

Report Bursting is nothing but distributing reports to all the users who can see and take some decesitions and if any modification has to done they can suggests.Not only the by using BCA we can refresh the reports and schedule the reports.Cheers,Jaya

Answer Question  Select Best Answer

vasu

• Oct 26th, 2007

I think we cannot create a cube physically but logically in drilling process. U can pick up the 2 dimensional view of the cube by drilling.

Karv

• Dec 4th, 2006

A cube in Bo is nothing but the resultset of the query or the data providor. I  think we dont create a cube explicitly.

Answer Question  Select Best Answer