It can be done by putting a condition in the where clause of data provider...
like...
Date between prompt('Enter From Date') AND prompt ('Enter To Date')
run the report. it will ask you to enter the from_date and to_date and will fetch the records accordingly
I hope this is what you needed
Do you want a field in the report that will say the Date on which the report was refresh or run.
Add a variable "<var>" with formula
=LastExecutionDate("data provider name").
If you create a new data provider with only two queries only, (6+3) measures. Does these queries contain the tables you dont need and is the output is correct...?
Hi.
Business Objects does not support this..
But if you want to customize your report as per this requirement you can do through vba scripting.
All you need is to add to write the script in the before refresh event.
create user form that will look like as of BO prompt window.
And fetch the...
In BO you can create reports through... universe(created through the designer module), stored procedures, vba, and data files.
If you have a installed utitlities with BO then u can see all the sample reports and universes created.
Why dont you go through the online guides available with BO.
Go...
Hi
Initially I asked you to try with DayDiff through VBA.
DayDiff calulates the Hours betn 2 dates.
But this folmula is not taken for the new variable you add.
If anybody knows "how to put calculated values in the local variable?" will be a great help, this variable is created...
Hi
You need a add a variable through VBA script.
There is a function called daydiff in VBA, (pass the paramter h for hour, m for minute, as interval)
Shyam
webi identifies the repository database through bomain.key,
it does not identifies any other <name>.key
bomian.key has all the information, I think you need to keep bomain.key in LocData folder.
Since you have copied the bomain key from other m/c and put it on the server. You need to create...
Hi.
I tried some demos to get this error.
when I changed the system time so that it will not in between the service license period, then I received this error.
So this error may occur if your service license of BO is over.
Check out the license period.
Check the rights of user. It may possible that some objects or the universe are restricted for the user. This generally happens initially when the user has all rights and then put on some restrictions
Is it the case that user can open the document in BO and the same user cant open in InfoView
Hi.
Is this document run any macro if yes please check out the macro script cause this error may display when there is a incorrect macro script.
Check whether any of the commands in macro involve unauthorized rights or access to restricted resources, like invoking a restricted universe or data...
Hi.
There is no solution for this. You can not create a report on the variables that are not linked.
To avoid this.
Since your universe is the same, select all the variable in one data provider.
If in case you have two universe, and you want to use these unverse for creating one report.
Then...
Webi allowed only universe as source for creating new documents in WEBI.
You can create a document in BO and send it to the repository, ans have a zabo installed on the server.
Shyam
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.