BusinessObjects Board

How to generate new reports and save in excel.

sdk development
#1

:crazy_face: :?
Hello,
I just started working with BO cureently working on Conversion project from Cognos to Business Objets.
In cogons we have Many cubes which i simulated to BO and provided the same funcitonality with Drill down options.
In cognos they r generating multiple powrplay reports from Cube According to region/city/station with the help of MACROS, Iqds and distributing to the respective stations every day.

Is there any way i can do this in Business Objects and automate the process.

PROBLEM:-

  1. I have to generate and Distibute these reports Daily basis and save it in EXCEL format.
  2. Please guide me from where i can start.
  3. I have to use do this in both BO and WEBi Version 5.x/6.1

Can any one help me in solving this problem and Help in settle down in job.

Thanks & Regards
bouser_1@hotmail.com

bouser_1 (BOB member since 2004-03-20)

#2

Yes you can do this by using VBA and BCA let me know your exact requirement and I can share the script.

VikasH (BOB member since 2004-03-18)

#3

I have a very similar problem. Can you share the information with me, please.
Email : db4me2000@yahoo.com

I have a report that takes an input parameter (Entity_Id). The list of Entity_Id?s is in a database (same database as the data in the report). There are about 8000 Entity_id?s. The requirement is to run the report for each Entity_id and save as HTML in the directory named after Entity_id. Therefore, in the end I have to end up with 8,000 directories containing html file and imbedded graphics. What is the most efficient way to automate this process? Where can I find information on how to create VBA macro with BO (need tutorial with examples)? Thank you!

db4me2000 (BOB member since 2004-04-15)

#4

To get started take a look at this presentation from Integra Solutions and at this post on how to convert reports to MS Excel.

Andreas :de: (BOB member since 2002-06-20)

#5

Here is the script I used for this kind of requirement.
bouser1 can you share how you simulated Cognos Cubes with drill down in BO please?

kalyanimay30@yahoo.com

Sub main()

Dim boUni As busobj.Universe
Dim boclass As busobj.Class
Dim bosubclass As busobj.Class
Dim boObject As busobj.Object
Dim ParameterValues

Dim p_info As String
Dim v_Reportname As String
Dim v_DateParamArray(10) As String
Dim v_EmailParamArray(10) As String
Dim v_location As String
Dim v_loop_counter As Integer
Dim v_LoginCount As Integer
Dim i As Integer

Dim v_Doc As busobj.Document

Set boUni = Application.Universes.Item(“Universe Name”)
Set boclass = boUni.Classes.Item(“Class Name”)
Set boObject = boclass.Objects.Item(“Object Name”)
boObject.ListOfValues.Refresh
ParameterValues = boObject.ListOfValues.Values

LoginCount = UBound(ParameterValues)

v_Reportname = ActiveDocument.Name
Set v_Doc = Application.Documents.Item(v_Reportname)
Application.Interactive = False
v_location = “\xxxxxxx\d$\yyyyyy\BCA Mail”

For i = 1 To LoginCount

v_Doc.Variables.Item(“Enter The Login :”).Value = ParameterValues(i)

v_Doc.Refresh

v_Doc.ExportAsPDF (Trim(v_location) & v_Reportname & ParameterValues(i))

Next i

’ Set objmail = CreateObject(“CDO.Message”)
’ objmail.from = “xxxxxx”
’ objmail.to = “yyyyyyyy”
’ objmail.Subject = “BCA Email Test”
’ objmail.textbody = "Please find the attached report : " & v_Reportname
'objmail.AddAttachment v_location & v_Reportname & “.pdf”

  'objmail.Send

’ Set objmail = Nothing

Application.Interactive = True

End Sub

VikasH (BOB member since 2004-03-18)