Search results for query: *

I need to hide some columns in a report that some users don't have the rights to view. e.g if i have a report with SSN along with other columns, only the admin user should be able to see the SSN column in the report while a normal user should not see this column. This should be done in the same...

Hi all, I have a very bulky report that has lots of individual tables, filters and formaules (can't avoid). When i change the value of even a single cell, it shows the message at the bottom "Computing Data" and then "Computing Display" and this whole process takes upto 5 mins (100% CPU usage) on...

hi, i am using the BO ver 6, formatdate() function to convert a date to a string. i am passing a dimension which has date value as the first parameter and "mm/dd/yyyy" as the second. the dataprovider is VBA and the database is DB2. FormatDate(<datedimension>,"mm/dd/yyyy") however, this is...

hi, i am using the BO ver 6, formatdate() function to convert a date to a string. i am passing a dimension which has date value as the first parameter and "mm/dd/yyyy" as the second. FormatDate(<datedimension>,"mm/dd/yyyy") however, this is giving me #ERROR. any suggestion on how to rectify this...

Hi all, I have a cross tab report that goes accross the page and below based on the section delimiter. I have a cell and a table on top of the cross tab to display the section delimiter value and other parameter. I am able to make this cell and table repeat below on every page but not accross...

Can anyone send me a sample code to include the FileWatcher class in my Reoprt in VBA? I need to automate reports based on the presence of a file. Also wanted to know if i can pass report parameters in this file and make BO read them. I was trying with the follwing code in VBA...

We have BO reports with VBA as the dataprovider. I use VB forms for user credential validation and also for them to select the database schema, tablename and other details. When i refresh the BO report, all these forms pop up in an orderly fashion and allow users to enter the data. This is...

I am using a BO report which has a VBA data provider. This builds SQL dynamically based on the table and other selections that the user makes in the VB form. Due to this, BO always shows a message at the end of document refresh : "Modified Data Provider. The data provider now contains...

I have my BO reports (crosstabs) running accross(horizontally) to multipal pages. But the problem i find is that for the multiple crosstabs formed based on the master-detail format, BO takes the horizontal length of the first cross tab as the default and then displays the length of all other...

Hi, I need to create a Parallel routine using C program and then call it in a transformer. Although I am able to create a simple C routine, compile it and see the same in the Parallel Routine, I am not able to call the same in the transformer. I did the required as per the documentation but yet...

Hi, We have a universe built on a particular schema in the DB2 database. There is a need to change to a different schema on the same database with the same tables. Do i need to recreate the universe all over again (i have done lot of formatting with the universe objects already)? Is there any...

I want to calculate sum on a column that has been calculated using the Previous() function. There is a measure field called <Cell Count> and i have created another column in report which has formula Previous(<cell count>). There is a section break in the report based on another dimension. Now...

Hi, Is it possible to display a list of values in a prompt as a selection of some values from a table column and not by hardcoding the list of values in the @prompt syntax. Syntax: @prompt('prompt','data type',{'value','value', etc.},mono/ multi,free/constrained) Can i make the...

Hi, I need to use VBA for building a data provider in BO. I am pretty new to using the same, so any help on this with a link/doc that provides good info/example to write a VBA script to build a data provider would be greatly appreciated. Thanks in advance Bin

Hi, I want claculate a formula where i have to use the previous value of the same variable i am calculating in the formula &quot;cumulative frequency&quot; = &quot;frequency&quot; + previous value of &quot;cumulative frequency&quot;. But when i use the Previous() function in BO it give me an...

Hi, I am having BO version 5.1.7 and DB2 client version 8.1 I am able to successfully connect to the DB2 database using the IBM DB2 ODBC, but in the BO Designer, when i run the wizard, it gives me the following error: &quot; Error in retrieving tables.&quot; [IBM][CLI Driver] CLI0150E Driver...

Hi, I want to display the user who refreshed the report previously. Bo has the function to diaplay the Last Refresh Date, but i am not able to find any &quot;Last Refresh By&quot; function. Can anyone help in this regard? Thanks Binoy

Does DB2 UDB V8 provide a table like the DUAL table in Oracle? If no, then what is the work around?

Hi, I have three questions: 1. Can i have the same client accessing multiple repositories on different servers? 2. Can I have the same Broadcast Agent working for two different servers(repositories) 3. Can i have multiple servers for the same repository? Thanks Binoy Mathew Joseph...

Hi, Is it possible to create multiple instances of Teradata on the same Unix machine? Can i create more than one superuser on the same Unix machine? Currently i am having a development database in Teradata on Unix(NCR Worldmark Server) and i want to move into production. How can i do that? Can i...