Thursday Apr 26, 2012

Macro Can not be Found Error

There have been messages on the forum and via email in the past few weeks about an issue that occurs with MS Word Template Builder. It appears that the latest MSOffice patch breaks all versions of the Template Builder prior to 11.1.1.6. You'll get an error similar to: 

'The macro cannot be found or has been disabled'

It actually appears to not only break our plugin but any VBA based code that might be embedded inside MSWord.

Rather than re-regurgitate the current work around (we're assuming MS will get a fix out at some point) Im pointing you to Damir's blog entry here.

http://damir-vadas.blogspot.co.uk/2011/02/macro-cannot-be-found-or-has-been.html

Jim from S&C Electric let me know of another solution:

We had a similar issue.

Our fix was the find the files with exd extensions and change the name so they were not available.

Maybe this will help.

Thanks Jim

Friday Feb 17, 2012

Rocky Mountain User Group Preso

For those of you that could not make the Rocky Mountain User Group session yesterday. Nikos, from the product management team has kindly loaded my presentation and the sample templates I showed, up to OTN. Its a bit of a monster so be patient.

http://www.oracle.com/technetwork/middleware/bi-publisher/beyondthelistingreport-1526340.zip

Its worth 'running' the powerpoint for the fantastic comedic moments we shared in the room, well, kinda. You need my deep southern Louisiana accent for the full effect :0)

Sunday Oct 09, 2011

BIP and Mapviewer Mash Up III

This is the third installment of the BIP and Mapviewer Mashup, for the previous entries:

BIP and Mapviewer Mash Up I

BIP and Mapviewer Mash Up II

BIP and Mapviewer Mash Up III

Its been a hectic couple of weeks which has included all things mapviewer and integration. I have finally got my piece de resistance in mapping integration working but more on that next time. Its very cool in a geeky BIP, kinda way; my wife was completely fascinated when I told her all about it over dinner last night. Either that, or she has become very adept at nodding and saying 'that's nice honeycakes' at appropriate times. I hope the former but suspect the latter :0(

The next part of this mashup series, I said we would parameterize the map call. That's actually pretty easy to do, just a bit more effort with the parameters and the concat functions.

1. Set up your parameters in the data model. These do not have to be tied to the query. We support 'template ' only parameters. they just all have to be defined in the datamodel. Note the name you give to the parameter(s)

2. In your RTF template you need to declare 'interest' in the parameters. Its the same as the CURRENT_SERVER_URL format.

<?param@begin:name;defaultvalue?>

3. In the fields where you are building the encoded request string you can use the concat function to drop the parameter values into the string. In this case we are changing th map title with a parameter called 'title'

 <xsl:param xdofo:ctx="begin" name="pMapRq">concat
("%3Cmap_request%20title%3D%22",$title,
"%20basemap%3D%22world_map%22%20datasource%20%3D%20%22
obiee_navteq_sample%22%20width%3D%22640%22%20height
%3D%22480%22%20bgcolor%3D%22%23a6cae0%22%20antialiase
%3D%22false%22%20format%3D%22JPG_STREAM%22%3E")
     </xsl:param>

Its not tough but boy is it a bit of a nightmare to manage and keep track of everything in that encoded URL.

As I mentioned in my last post its a good idea to maintain the parts of the URL as un-encoded text in the template surrounded by an 'if:1=2' if statement to keep it hidden at runtime.

Next post, we get to a much more robust, easier to manage and as I mentioned cooler solution ... enter the mapping servlet. It acts as a map request broker between the BIP template and the mapviewer server. The RTF template is not full of encoded URLs but just a simple URL call to the servlet that will call the mapviewer server and stream the image back to BIP for rendering. I have built in a couple of tricks but more on that next time.

Tuesday Sep 27, 2011

BI Publisher sessions for Oracle Open World 2011

OOW

Are you coming to Oracle Open World 2011?

No?  There's still time to register!  The conference starts Sunday, Oct 2nd

Yes?  Great!  This year, in addition to the awesome sessions and demo pod, there are several hands on labs where you can get your hands on the product.

For a list of all the sessions that will highlight BI Publisher, please check out the Focus On Business Intelligence Publisher handout.

Be sure to add these sessions using the Schedule Builder, so you can be assured a spot. 


BI Publisher Demo Pods:
Oracle Business Intelligence Publisher    Moscone South, Right – SR-287
PeopleSoft PeopleTools     Moscone West – W-074

Oracle DEMOgrounds Schedule:

MONDAY, OCTOBER 3:     9:45 am – 5:30 pm
TUESDAY, OCTOBER 4:    9:45 am – 6:00 pm
WEDNESDAY, OCTOBER 5:    9:00 am – 4:00 pm



Sessions and Hands On Labs:

Everyone


Sun 2-Oct 1:00 pm – 1:45 pm

28541: Upgrading Your Oracle BIEE Software? Leverage 11g New Features
Moscone West 2011

Mon 3-Oct 3:30 pm – 4:30 pm    32020: Building Reports and Data Models in Oracle Business Intelligence Publisher 11g

(HANDS ON LAB)    Marriott Marquis - Salon 5/6

Mon 3-Oct 5:00 pm – 6:00 pm    14982: Create All Your Reports More Easily and Quickly with Oracle Business Intelligence Publisher   

Moscone West 3024

Mon 3-Oct 5:00 pm – 6:00 pm    12426: Oracle Business Intelligence Publisher: The Reporting Platform for Oracle Applications  

Moscone West 2022

Wed 5-Oct 1:15 pm – 2:15 pm    32020: Building Reports and Data Models in Oracle Business Intelligence Publisher 11g 

(HANDS ON LAB)    Marriott Marquis - Salon 5/6

Wed 5-Oct 5:00 pm  - 6:00 pm    16762: Become a Reporting Superstar with Oracle Business Intelligence Publisher Best Practices  

Moscone West 2002/2004

Thr 6-Oct 1:30 pm – 2:30 pm    15010: Oracle Business Intelligence Publisher: Anatomy of a Template

Moscone West -  2000



JD Edwards Enterprise

Tue 4-Oct 10:15 am  - 11:15 am    8009: Operational Reporting with Oracle Business Intelligence Publisher and JD Edwards: Success Story     Moscone West 3008

Wed 5-Oct 1:15 pm – 2:15 pm    15308: Simplify Your JD Edwards Reporting with Oracle Business Intelligence Publisher   

St. Francis - St. Francis Suite East

Thr 6-Oct 10:30 am -11:30 am    21406: Empower JD Edwards Users with Oracle Business Intelligence Publisher for Ad Hoc Reporting

(HANDS ON LAB)
Marriott Marquis - Nob Hill AB

Thr 6-Oct 12:00 pm -1:00 pm    21406: Empower JD Edwards Users with Oracle Business Intelligence Publisher for Ad Hoc Reporting

(HANDS ON LAB)   
Marriott Marquis - Nob Hill AB


Primavera


Tue 4-Oct 10:15 am  - 11:15 am    9774: Primavera Application Users, Welcome to Oracle Business Intelligence Publisher

Moscone West 2016

Thr 6-Oct 9:00 am - 10:00 am    29803: Using Oracle Business Intelligence Publisher with Primavera Contract Management

(HANDS ON LAB)   
Marriott Marquis - Nob Hill CD


E-Business Suite


Sun 2-Oct 11:45 am –  1:00 pm    28214: Business Intelligence (BI) Publisher OAUG SIG  

Moscone West 3006


Siebel

Tue 4-Oct 5:00 pm – 6:00 pm    18234: Building More-Insightful Reports with Siebel Reporting Solutions
Moscone West 2010


PeopleSoft


Thr 6-Oct 10:30 am – 11:30 am    14002:  PeopleTools Developer Series: Mastering PeopleSoft's Reporting Tools  

Moscone West 2024

About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
21
22
23
24
25
26
27
28
29
30
31
      
Today