- SAP Community
- Products and Technology
- Additional Q&A
- Somebody experience with outlooksoft
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Somebody experience with outlooksoft
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 08-28-2007 1:11 PM
Hi,
Does somebody has experience with using Outlooksoft for budgetting or forecasting? What are the benefits of it, how can we see the integration with SAP BI IP or SAP in general. Does anyone has good documentation on this topic?
Is it expensive? How much is the license cost?
D
Accepted Solutions (0)
Answers (2)
Answers (2)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
There is SAP certifed integrator for OutlookSoft-BPC. iNet.BI for SAP, several large SAP customers are using it to move data from BW (3.1,3.5,7.0) and from ECC to BPC (Outlooksoft)
Set-up of packages requires no coding, and all works from within the BPS Data Manager and SSIS.
paper on its use at https://portal.erp-link.com/Projects/default.aspx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Dries,
I will try and provide some information on your questions. Firstly, when I refer to SAP BPC (Business Planning and Consolidations), I am refering to the product formerly called OutlookSoft 5.0, as this is the name of the product now it is being offered from SAP.
Q) Where to get more info.
There are several places you can check out. I would recommend taking a look at some of the blogs on CPM topics (for example:
- <a href="/people/ryan.leask/blog/2007/07/25/corporate-performance-management-departmental-or-corporate blog</a>
- <a href="/people/prakash.darji/blog/2007/07/25/sap-business-planning-consolidations-outlooksoft-vs-bi-integrated-planning blog from Prakash Darji</a>
- <a href="https://weblogs.sdn.sap.com/pub/u/251813988">Some blogs from Muthu Ranganathan</a>
- If you are interested, I am also planning to release another blog shortly that describes a bit about the overall CPM roadmap, so stay tuned.
You can also take a look at the product demo's on the old OutlookSoft website. Specifically <a href="http://outlooksoft.com/us/demo/index.html">this is the demo page.</a>.
If you have Service Marketplace user ID, you can also access product documentation <a href="https://service.sap.com/~form/sapnet?_SCENARIO=01100035870000000202&_SHORTKEY=00200797470000084442&">here.</a>
There is also plans for training obviously, and we will also have a CPM page up and running on BPX/SDN shortly.
Q) Integration with BI-IP or SAP in general.
As OutlookSoft is a recent acquisition for SAP, the tight integration to the NetWeaver BI platform is currently under development. That means today you will need to load data to BPC from any relevant system, including SAP ERP, NW BI, or other non-SAP systems. If you wanted to, you could also of course extract the data out of BPC and load it back up into NW BI (for example). We will publish some How To guides and/or White Papers on integration approaches shortly.
In terms of future integration, the first step is to integrate the OutlookSoft solution with the NetWeaver BI stack next year. Integration to BI-IP will come in the subsequent release (more details in my blog to come).
Q) How much is the license cost?
Customers need to contact their SAP Account Executives for all license related questions.
Hope this helps.
Regards,
Ryan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
BTW - there is one more link you might be interested in.
This is current OutlookSoft <a href="http://outlooksoft.com/us/services/training_course_schedule.asp">Training Schedule</a>, which offers both Web and Classroom based training. This link takes you to the OutlookSoft website, but training will of course move to SAP Education over time.
Regards,
Ryan
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Ryan,
I need to compare SAP Netweaver BI 7.0 and Outlooksoft 4.2 performances with great volumes of data to elaborate (totally 3-4.000.000 of records), who is the best in writing and who in reading?
There is an official document that compares these platforms (or also the old BW and OS 4.2)?
We are evaluating the best platform to develop FI-Allocation (Distribution and Assessment) with great volumes of data and many allocation dimensions.
Thank you,
Claudio
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hey Claudio,
3-4 Million Records is on the low side of data volumes so both solutions should perform pretty well. Also, it will depend on what you're trying to do specifically with the records, so if you could post more details on your scenario that would be helpful, but in general, both solutions should perform well for 3-4 million record cubes... If you have lots of dimensions (over 20), then using ROLAP cubes from NetWeaver would probably be more efficient...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Claudio,
There are a lot of variables that can impact performance, so its probably not possible to make a blanket statement that one solution is 'faster' than the other.
As Prakash said, if you can post more details, we can try and help you make a decision.
I would suggest opening a new post so we don't thread jack...
Regards,
Ryan
(PS - Why OutlookSoft 4.2 not 5.0?)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
Please continue this discussion because I"m interested in performance as well. Currently we are implementing BI IP and have workbooks with 4 - 8 layouts (tabs) reading on actual data having 5 - 6 million records.
Our finding is that it is not performant at all. Problem is not the BI IP itself but the BI BEX reporting in general. It takes like 4 - 8 minutes to just open the workbook. We have similar experiences with other projects ... Each time we execute a function a lot of time is lost for refreshing the other data in the workbook. Tracing says 50% is lost on data reading (which we can improve -> we are working on this) but the other 50% is for preparing and updating the layout in excell,
=> I am really searching for some examples / references with planning applications reading on > 5 million records and integrated in BEX BI IP planning tools.
D
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hey Dries,
All customers working with BI-IP should look at this note!
1056259 - Collective note: Performance of BI planning
This note gives you an overview of the most important factors which influence performance that you need to take into account when you create planning applications in BI planning.
Cheers,
Prakash
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Prakesh,
I already have looked at this note before. Like I said, it is not planning related but more general BEX reporting. For example a simple standard save takes a very long time, opening workbook takes a very long time, (because we have 4 - 8 layouts reading 5 million of records each).
A lot of time is lost by the step mentioned in the OSS note:
a) BEx Analyzer: The system converts the data from the abstract grid format and uses Remote Function Call (RFC) to transfer it to the .NET runtime of the BEx Analyzer. This triggers rendering in Excel.
Tomorrow I'll check the differences using different front-end PC.
D
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hey Dries,
If you haven't looked at the new stats cubes, there are quite a bit of details available around the performance for this transfer of data... Here's a breakout of all the events. Once you isolate which event id the time is being spent on, then let me know as this should provide more detail into the source of the issue.
Total Time - 0TCTSTATTIM
-> Total OLAP [2500-2599], [3000-3999]
-> Cache Time [2500-2599]
-> Generation of Cache Entry [2500]
-> Read Cache Entries [2505]
-> Write Cache Entries [2510]
-> Deletion of Cache Entries or Whole Cache [2515]
-> Commitment of Cache Entries [2520]
-> Counts the Read Accesses to the Cache [2525]
-> Counts the Write Accesses to the Cache [2530]
-> Olap Time [3000-3999]
-> Read OLAP Settings [3000]
-> OLAP Query Generation [3010]
-> OLAP: Transaction Data Access [3100 - 3199]
-> OLAP: Read Data [3100]
-> OLAP: Data Selection (Check...) [3110]
-> Checks whether an Infocube does not have to be read [3120]
-> Userexit IF_EX_RSR_OLAP_BAPI [3130]
-> OLAP: Data Transfer at Front End [3200]
-> Reading master data [3210]
-> Quantity Conversion [3310]
-> OLAP Initialization [3500]
-> OLAP: Read Texts [3900]
-> OLAP Other Time [3999]
-> Time DataManager [9000 - 9999]
-> Data Manager Event [9000]
-> External Call of the Data Manger (RSDRI) [9001]
-> Execution of Delta Cache Test [9002]
-> Total Number of Transported Records (DBTRANS) [9010]
-> Total Number of Read Records (DBSEL) [9011]
-> Time front-end [1000-1999], [10000], [12500-49999]
-> Front End - Non-Assigned Times [1000]
-> Remote Call of a Function Module [10000]
-> Application Step [12500]
-> BI Consumer Services [13000-13099]
-> Build BI Consumer Services Initial View [13001]
-> BI Consumer Services View [13002]
-> BI Consumer Services Master Data Access [13003]
-> Load BI Consumer Services Result Data [13004]
-> Load BI Consumer Services Provider Result Data [13040]
-> ABAP BICS Time [13050-13059]
-> ABAP BICS Provider Initialization [13050]
-> Load ABAP BICS Status [13051]
-> Set ABAP BICS Status [13052]
-> Read ABAP BICS Master Data [13053]
-> Read ABAP BICS Result Set [13054]
-> Generate ABAP BICS Output Data [13055]
-> Set ABAP BICS Hierarchy [13056]
-> Read ABAP BICS Hierarchy Master Data [13057]
-> ABAP BICS Miscellaneous [13058]
-> ABAP BICS New Plan Data [13059]
-> Total Web Java [12600-12699], [13100-14599]
-> Web Java [12600-12699]
-> Web Java: Process Request [12600]
-> Web Java: Build Whole Page [12601]
-> Web Java: Rendering of the Items [12602]
-> Web Java: Return Binary Content [12603]
-> Web Java: Late Rendering of the Item [12604]
-> Web Java: Return Text-Type Content [12605]
-> Web Java: Send Event [12606]
-> Web Java: Read Local MIME File [12607]
-> Web Java: Page: Command Processing [12608]
-> Web Java: Page: Reading the Customzing Data [12609]
-> Web Java: Data Provider [13100-13199]
-> Web Java: Data Provider: Initialize [13100]
-> Web Java: Data Provider: Command Processing [13101]
-> Web Java: Data Provider: Release [13102]
-> Web Java: Data Provider: Send Event [13103]
-> Web Java: Data Provider: Set Status [13104]
-> Web Java: Data Provider: Save Status [13105]
-> Web Java: Data Area Provider [13200-13299]
-> Web Java: Data Area Provider: Initialize [13200]
-> Web Java: Data Area Provider: Command Processing [13201]
-> Web Java: Data Area Provider: Release [13202]
-> Web Java: Data Area Provider: Send Event [13203]
-> Web Java: Data Area Provider: Set Status [13204]
-> Web Java: Data Area Provider: Save Status [13205]
-> Read Documents [13300-13399]
-> Read InfoProvider Doc. from DB/RM (incl. Cells with Icons) [13300]
-> Read Master Data Documents from DB/RM [13310]
-> Read Metadata Documents from DB/RM [13320]
-> Web Java: Item [14100-14199]
-> Web Java: Item: Initialize [14100]
-> Web Java: Item: Command Processing [14101]
-> Web Java: Item: Release [14102]
-> Web Java: Item: Send Event [14103]
-> Web Java: Item: Set Status [14104]
-> Web Java: Item: Save Status [14105]
-> Web Java: Dialog [14500-14599]
-> Web Java: Dialog: Initialize [14500]
-> Web Java: Dialog: Command Processing [14501]
-> Web Java: Dialog: Release [14502]
-> Web Java: Dialog: Send Event [14503]
-> Web Java: Dialog: Set Status [14504]
-> Web Java: Dialog: Save Status [14505]
-> Broadcasting Time [14600-14699]
-> Broadcasting: Execute Setting [14601]
-> Broadcasting: Execution of Producer, Distributor, ... [14611]
-> Broadcasting: Determine Properties of Base Object [14671]
-> 2004s BEx Analyzer Excel Time [15000-15999]
-> Load Workbook [15001]
-> Generate Workbook [15002]
-> Read Data [15003]
-> Render Item [15004]
-> Process Command [15005]
-> Draw Symbols [15006]
-> Deserialize Metadata [15007]
-> Deserialize Result Set [15008]
-> Number of Excel Cells [15010]
-> Number of Blocks [15011]
-> Number of Symbols [15012]
-> Process Dialog [15013]
-> Serialize Result [15014]
-> Serialize Request [15015]
-> BW 3.x BEx Analyzer Excel Time [19000-19909]
-> 3.x Analyzer Server Logic [19900]
-> 3.x Analyzer Client Time [19901]
-> BW 3.x Web Runtime [19910-19999]
-> 3.x Web Reporting General [19910]
-> 3.x Web Reporting Item Rendering [19911]
-> Close Web 3.x [19919]
-> 3.x Query View Open [19950]
-> 3.x Query View Status Check [19951]
-> 3.x Query View Data Access [19952]
-> 3.x Alert Monitor Data Access [19970]
-> 3.x Batch Printing [19971]
-> 3rd Party Access [40000-49999]
-> OLAP BAPI [40000]
-> Create MDC Runtime Object [40001]
-> Delete MDX Runtime Object [40002]
-> MDX Execution [40010]
-> MDX Execution (Initialization) [40011]
-> MDX Execution (Axes) [40012]
-> MDX Execution (Transaction Data) [40013]
-> Read MXS Query Object [40020]
-> MDX Axis Data [40030]
-> MDX Axis Info [40031]
-> MDX Cell Data [40032]
-> MDX Flattening [40033]
-> Time Planning [50000-59999]
-> Planning: Writing Delta Records [50000]
-> Planning: Enqueue [50001]
-> Planning: Characteristic Derivation [50002]
-> Planning: Saving Data [50003]
-> Planning: Execution of a Planning Function [50010]
-> Number of Read Records [50011]
-> Number of Changed Records [50012]
-> Number of Deleted Records [50013]
-> Number of Read Reference Data Records [50014]
-> Time Other
-> Global Event for "Non-Assigned" Times [0000]
-> Wait Time of User [0001]
-> Authorization Check [4000 - 4999]
-> Authorized Values and Intervals [4300]
-> Authorized Hierarchy Nodes [4400]
-> Authorization Check Selection [4500]
-> Authorization Check Selection Old (up to BW 3.5) [4510]
-> Filling the Authorization Buffer [4600]
-> Filling the Authorization Buffer Old (up to BW 3.5) [4610]
-> Aggregated Events (No Detailed Info Recorded) [99999]
Cheers,
Prakash
Message was edited by:
Prakash Darji
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Ryan,
I am an SAP Partner (with Akili). We were an OutlookSoft implementation partner before, so I am getting used to the SAP SMP, etc. I am trying to access Note #1087086 referenced by the BPC 5.1 Installation Guide. I think my SMP ID may not have been setup correctly by my super admin; I can login to SMP OK but when I try to access that note, I get challenged again for username and password. The one I used to successfully login to SMP does not work. My super admin is out of pocket at the moment; can you email me note #1087086 at ppetersen@akili.com?
Thanks,
Paul Petersen
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
> Hi Dries,
>
> I will try and provide some information on your
> questions. Firstly, when I refer to SAP BPC (Business
> Planning and Consolidations), I am refering to the
> product formerly called OutlookSoft 5.0, as this is
> the name of the product now it is being offered from
> SAP.
>
> Q) Where to get more info.
> There are several places you can check out. I would
> recommend taking a look at some of the blogs on CPM
> topics (for example:
> -
> <a href="https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub
> /wlg/7005">My blog</a>
> -
> <a href="https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub
> /wlg/7004">A blog from Prakash Darji</a>
> -
> <a href="https://weblogs.sdn.sap.com/pub/u/251813988">Some
> blogs from Muthu Ranganathan</a>
> - If you are interested, I am also planning to
> release another blog shortly that describes a bit
> about the overall CPM roadmap, so stay tuned.
>
> You can also take a look at the product demo's on the
> old OutlookSoft website. Specifically
> <a href="http://outlooksoft.com/us/demo/index.html">this
> is the demo page.</a>.
>
> If you have Service Marketplace user ID, you can also
> access product documentation
> <a href="https://service.sap.com/~form/sapnet?_SCENARIO=01
> 100035870000000202&_SHORTKEY=00200797470000084442&">her
> e.</a>
>
> There is also plans for training obviously, and we
> will also have a CPM page up and running on BPX/SDN
> shortly.
>
> Q) Integration with BI-IP or SAP in general.
> As OutlookSoft is a recent acquisition for SAP, the
> tight integration to the NetWeaver BI platform is
> currently under development. That means today you
> will need to load data to BPC from any relevant
> system, including SAP ERP, NW BI, or other non-SAP
> systems. If you wanted to, you could also of course
> extract the data out of BPC and load it back up into
> NW BI (for example). We will publish some How To
> guides and/or White Papers on integration approaches
> shortly.
>
> In terms of future integration, the first step is to
> integrate the OutlookSoft solution with the NetWeaver
> BI stack next year. Integration to BI-IP will come in
> the subsequent release (more details in my blog to
> come).
>
> Q) How much is the license cost?
> Customers need to contact their SAP Account
> Executives for all license related questions.
>
> Hope this helps.
>
> Regards,
> Ryan
Hi, Ryan
what method is being used to load data from ECC to BPC and from BPC to ECC?
CS
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- SAP Queries/Infoset Queries data import to SAC (SAP ECC not on HANA) in Technology Q&A
- SAP Sustainability for Financial Services - Portfolio and Solutions in Financial Management Blogs by SAP
- Enhanced RISE with SAP Methodology with clean core quality checks in Enterprise Resource Planning Blogs by SAP
- Jumpstart your cloud ERP journey with guided enablement in RISE with SAP Methodology in Enterprise Resource Planning Blogs by SAP
- SAP Ariba Procure to Order 2405 Release Key Innovations in Spend Management Blogs by SAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.