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...

Thanks blom, however I found the following solution: I created an object in my universe stating: convert(datetime, '12/31/' + @Prompt('Enter reference year','A',,MONO,FREE)) (I am using Sybase Adaptive Server) when I need to compare dates I can use the @Select(object) in my condition...

The user doesn't exist in more than 1 place. I scanned and repaired all domain: there were no corruptions and it didn't solve the problem. It's weird, I can't find an logic behind this issue. Cheers, Serge

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 Steve, Your solutions works: I already tried it. However, I don't think it is a structural solution. It would mean that whenever something changes for an existing user the user's .lsi file has to be deleted. Doesn't it? Serge Schokkenbroek Ordina Finance Business Solutions http://www.ordina.nl

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...

Blom, Thanks for your reply. I've tried the addin, however, it doesn't do what I need. It only lists the code/definition of the columns in the report. It doesn't tell me anything about the definition of the report structure etc. Too bad. Thanks, Serge

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...

Thanks promero, Life can be so simple :) Serge

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...

Promero, thanks for all your support. I think I will opt for the solution with contexts because putting the Aggregate_Aware in a condition object results in some other conflicts in my situation. Thanks, Serge

ssibo, what do you mean with "matches pattern"? Where can I choose for this? Serge

Promero, I am encountering an error following your advise: Like I said, I have an dimension object Entity. The select clause is @Aggregate_Aware(Entity2.description, Entity.description). I showed you the where-clause and you showed me how the rebuild the where-clause. Now I am getting an error...

Promero, thanks for your explanation. If you don't mind I have two questions about your tip: 1) In my universe I have the dimension object Entity. The select-clause is: Entity.description. I've changed it to @Aggregate_Aware(Entity2.description, Entity.description) The where-clause is...

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...

Hello SaraMaia, If you mean with 'filter' an applied condition I don't think it's possible to show the name of the condition. However, if you refer to a filter which you applied using the report structure window you can do the following to insert the value of the filter: Choose from the menu...