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...
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
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...
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
Blom is right Ver 7.x has Union Transformation... Now in your case what you need to do is Override the SQL of the Source Qualifier with a Union statement to get the functionality you are looking out for...
Sri
Looks like I didn't understand the exact stuff you are looking at... When you say Header Across Page what exactly are you looking out for??? I get the Header Repeated both Down and Across...
Can you put your request in alternate way so that I can check what you are looking at???
Sri
Did you check Repeat Header Across Page in the Page Break Across Section
Right Click - > Format Crosstab - > Page Layout Tab and see if both Down and Across Repeat Header is checked...
Also you need to switch to Page Layout to see the Header Repeating...
Sri
Couple of ways to do this... Either change the registry settings... Which I wudn't suggest... Instead use SDK to get back the menubar... Open a report or create a simple report maybe with eFashion... Then press Alt + F11 or open the VBA Editor... Press Ctrl + G and it should open the Immediate...
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.