Search results for query: *

Hi all, I am encountering the situation in which Impromptu doesn't allow me to make one of my report columns a list header. Also, when I try to group this column Impromptu gives me the red circle with white cross and shuts down. In my reporting I use several groupings and associations along...

Hi all, I would like to know something about main queries and subqueries. I've got 3 tables: A, B and C. The 3 tables have got the same PK, each composed of three attributes. Table B contains all possible combinations and is the leading table. The cardinalities are as follows: A -> B = 1:1...

Hi all, I am prompting a user to enter a year, f.e. 2002 (specified as number I guess). After that I want to select data from the database using something like: is valid on 31/12/entered year in this example 31/12/2002. How can I transform the entered year to the date 31/12/entered year...

Hi, I am encountering a problem with functionality offered in off line mode. My situation is the following. In supervisor I have created a user with limited functionality in Designer, f.e. it is not allowed to make new connections. In online modus and in off line modus everything works...

Hi all, I've defined a stored procedure in my database (Sybase Adaptive Server 12). Now, in my universe I want to use that stored procedure. Can someone explain the syntax to me? I am trying: procedurename(argument1, argument2) but I am getting the error that procedurename is not a built-in...

Hi all, I've got a question which seems rather trivial, however I am not able to do it. How can I print the definition of the Report, like one can do for the universe? I want to use it in my documentation set of my reports. I want to see on paper that my report uses to dataproviders, I want...

Hi everyone, I've inserted a pie chart in my report along with a legend. The max number of items in the legend is f.e. 8. I've based the size of the legend box on the maximum number of items. However, sometime the pie chart has only to different items, so in the legend box only two items are...

Hello all, I've got a problem with sorting the values of a generic dimension object. The situation is as follows. In BusinessObjects I have produced a report using two dataproviders (two seperate queries running on one and the same universe). From the result set I have constructed 1 report. I...

My mind is tired... Let's say I have 4 database tables: Entity, BusinessGroup Division and Department. Conceptually, there are two possible hierarchies: Entity BusinessGroup Division Department and Entity Division Department so there are divisions which relate directly to an Entity and...

Hi all, I am wondering if it is possible to force a specific Context to be used in a query. I've two Contexts. My reports is generated by using to queries (union). In query 1 either Context should be used and in the second query the ohter Context (not used in query 1) should be used. Is it...

Hi, I am encountering the following issue. In all of my source tables the actual data as well as the history date for that specific entity is kept. The most important attributes in those tables that tell if a specific record is valid at a certain point in time are 'effectivedate' and...

Hi there, Due to the fact that I have to set up my universes directly upon an OLTP-system I don't have the opportunity to set up something like a DWH adjusted to the reporting needs. So, I am encountering several problems of which the one below is an example. Imagine there are three tables...

Hi, It is possible to create a prompt asking the user to select one of the values in the declared list. However, I want to use a dynamic list of which the values are obtained from a specific database column. F.e.: In my database I have a table called Region containing three regions: region 1...