Recent content by Sridharan

If you have prompts in your document and when you schedule the document to BCA you will be asked for the Prompt Values during the Schedule process... Sri

One option to shun the messages shown by BO is to use SDK... Set Application.Interactive = False The above statement when executed will stop the User Interaction with BO... You could call that statement at appropriate place... So any message boxes, prompts etc will not be shown... Now after...

Laina, You need to define the Measure Object for the column retrieving the Fruit values and not on Customer... When you do so you will still get that many number of rows but when presented in the report you will get one row for each Customer... Again as I told earlier I dunno which version are...

A Star for Blom... Sri

That was a cool one blom... There was one more approach given by another user on BOB where you basically use the Sectioning trick to get the stuff in a single row... Really don't have the thread link in hand... Will post once I get hold of it... In essence we need to set the column containing...

Well may be I was not clear blom... When I said Min and Max its bit misleading... What he needs to do is take the Minimum of Period for each (Part, MonthEnd) and take the Start Value in One DP... In the second one he needs to take the Max Period for each (Part, MonthEnd) and take the...

I dunno which version are you on... Anyway check this thread and see if it works for you... http://www.forumtopics.com/busobj/viewtopic.php?t=29236 Sri

To your first question if its possible without creating a object at Universe Level Yes its possible... I've done something similar in the past... Lemme dig that up... Sri

Going with your already done stuff... You can have two DP's one fetching MIN value and other MAX value and then you can show these in the report along with Part and MonthEnd... Now if you don't like two DP approach drop a note I will provide an alternative solution... Sri

Also remember if some user drags a new object or removes already existing object your modified SQL doesn't hold good and BO will generate the SQL automatically... Sri

No No No... YOu don't need access to Universe... You can accomplish at the report level itself... Need to have a look at the report... Sri

I mean Are we talking in the same wavelength and not different stuffs??? Sri

Steve, Oh Ok... Now I got the point... Thanks... Kannan, You got that to working or you are looking out similar to what Steve mentioned like repeating the Section Value to repeat on Across the page with the crosstab... Say you have a section on Dim1 and you have a Cross Tab which spans across...

Glad to be of assistance [thumbsup2].. Sri

Time part can be there... But you need to accomodate that when you do a conversion... UserResponse will be a Detail but not a Dimension and you can actually take the Date Input and store in a Detail Variable... As said looking at the report might give some clues.. Sri