'sap'에 해당되는 글 59건

2012.05.11 Explorer with BWA
2012.05.10 Usage of BW7.3 Transformation Rule Type “Read from DataStore”
2012.05.10 Customizing Logon Page on Portal 7.3
2012.05.08 HANA vs. Exalytics: an Analyst's View
2012.05.04 Display Hierarchy in WEBi as displayed by BEx query
2011.12.08 All You Need to Know about HybridProvider in BW 7.30
2011.11.29 Enterprise Performance Management How-to Guides 1
2011.11.29 Using reCaptcha at SAP Portal 7.3 Logon Page
2011.11.29 Passing query parameters in background to a BEx report deployed in Enterprise portal
2011.11.29 HANA optimized planning with BW-IP

Technique/SAP BW2012. 5. 11. 12:25

Explorer with BWA

created by George Pertea

on May 10, 2012 8:31 PM, last modified by George Pertea on May 10, 2012 8:31 PM

Version 1

Installation and configuration of Explorer and BWA connectivity.

View Document

http://scn.sap.com/docs/DOC-28015

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60350c42-fc7c-2f10-cebf-eae652d0b296?QuickLink=index&overridelayout=true&54936926692076

저작자표시 비영리 동일조건

'Technique > SAP BW' 카테고리의 다른 글

DSO Comparison (0)	2012.08.03
SAP BW 7.3 Hybrid Provider (0)	2012.05.23
Usage of BW7.3 Transformation Rule Type “Read from DataStore” (0)	2012.05.10
Version management in SAP BW 7.3 (0)	2012.04.20
Queries/Workbooks a user can access (0)	2012.04.20

Posted by AgnesKim

Technique/SAP BW2012. 5. 10. 21:21

Usage of BW7.3 Transformation Rule Type “Read from DataStore”

Previous postNext post

Usage of BW7.3 Transformation Rule Type “Read from DataStore”

Posted by Suhas Karnik in Data Warehousing on May 10, 2012 1:48:27 PM

It is quite a common requirement to load data from point A to point B in BW, while performing a lookup on a DSO to get a bunch of fields from there.
This is usually implemented as follows: a SELECT statement the transformation Start Routine picks up data from the DSO and fills up an internal table, and an end routine (or field-level routines) populates the target fields by reading the internal table.

In keeping with the general BW 7.3 theme of automating common scenarios, a new transformation rule type has been introduced to do this automatically.
To take this new feature out for a spin, I created a DSO with loosely based on the 0FIAR_O03 DSO. My DSO had the key fields Company Code, Customer (0DEBITOR), Fiscal Period, Fiscal Variant, Accounting Doc No, Item No and Due Date Item No. It also had the data fields Credit Control Area, Debit/Credit Amount, Local Currency, Credit Limit and Currency.

I created a Flat File DataSource , which did not contain any fields for Credit Limit and Currency. The objective was to derive these two fields in the transformation from the Credit Management Control Area Data DSO (0FIAR_O09). To begin with, this is what the transformation from DataSource to the custom DSO looked like.

To perform the lookup, first the key fields of the lookup DSO have to be identified. The key fields of the 0FIAR_O09 DSO are Credit Control Area and Customer Number (0C_CTR_AREA and 0DEBITOR). The lookup logic will search the 0FIAR_O09 DSO based on these two fields. In order to do this, the Credit Control Area and Customer from the DataSource should be mapped to the Credit Limit key figure in the target.

The first step in the Rule Details is to specify the DSO from which the field values will be picked up – in this case, 0FIAR_O09. Next, the “IOAssgnmnt” column must be manually filled up with the names of the InfoObjects. It is important that ALL the key fields of the lookup DSO are specified.

In a nutshell, the above screen tells the system to derive the value of the 0CRED_LIMIT (the target field) from the 0FIAR_O09 DSO (the lookup DSO) based on the C_CTR_AREA and DEBITOR values coming in from the DSO, which correspond to the 0C_CTR_AREA and 0DEBITOR InfoObjects of the lookup DSO.

The 0CURRENCY target field also needs to be similarly mapped.

This is how the transformation looks after we're done. Observe the "DSO" icon which appears next to the Credit Limit and Currency in the target of the transformation.

Once this is done, run the DTP. The transformation will perform perform the lookup and populate the values. Activate the data when the load completes.
Now to begin verifying the data. The Flat file contained the following values, which were loaded to the PSA. Observe that there is no Credit Limit data in this file.

In the 0FIAR_O09 DSO, the following values were present.

After the load, this is how the data in the DSO looks.

As the screenshot shows, the transformation rule has correctly picked up the Credit Limit from the 0FIAR_O09 DSO.

A few caveats are in order on this feature.

All the key fields of the lookup DSO should be specified. If a partial key is specified (for instance, if we had mapped only 0DEBITOR in the source fields of the transformation rule) the system will assign the value from the first record it finds in the lookup DSO
The InfoObject Assignment for the source fields should have exactly the same names as the corresponding InfoObjects in the lookup DSO. If the InfoObject in the lookup DSO was 0CRED_LIMIT and the target InfoObject of the transformation rule was 0VALUE_LC, this technique cannot be used as the InfoObjects differ
The target InfoObject will be filled from the value of the InfoObject having the same name in the lookup DSO. In other words, 0CRED_LIMIT is filled up based on the value of 0CRED_LIMIT in 0FIAR_O09. If 0CRED_LIMIT did not exist in the lookup DSO, the system will throw an error during transformation activation

Essentially, this feature is most useful if you have simple lookups, for instance get Field X from DSO Y based on the lookup field Z and write it out in field X of the target. However, it may not be best solution if you have more complex requirements which involve

Pulling multiple records from the lookup DSO and getting the first or the last found record in the set
A lookup DSO in which the field you want has a different name

http://scn.sap.com/community/data-warehousing/blog/2012/05/10/usage-of-bw73-transformation-rule-type-read-from-datastore?utm_source=twitterfeed&utm_medium=twitter

저작자표시 비영리 동일조건

'Technique > SAP BW' 카테고리의 다른 글

SAP BW 7.3 Hybrid Provider (0)	2012.05.23
Explorer with BWA (0)	2012.05.11
Version management in SAP BW 7.3 (0)	2012.04.20
Queries/Workbooks a user can access (0)	2012.04.20
All You Need to Know about HybridProvider in BW 7.30 (0)	2011.12.08

Posted by AgnesKim

Technique/그외2012. 5. 10. 20:49

Customizing Logon Page on Portal 7.3

Posted by purav mehta in SAP NetWeaver Portal on May 10, 2012 12:59:15 PM

Please find below details steps for customizing logon page on Portal 7.3.

1. Locate the WAR file.

First step is to get the WAR file delievered by SAP for logon page to customize it.

Copy the war file tc~sec~ume~logon~ui.war to your local machine from

<Installation drive>:\usr\sap\<SID>\J00\j2ee\cluster\apps\sap.com\com.sap.security.core.logon
\servlet_jsp\logon_ui_resources\tc~sec~ume~logon~ui.war

2. Import the WAR file

Next we have to import the WAR file into NWDS by going to: File --> Import -->Web --> War File

Select the WAR file from the local system.

As EAR format can be deployed on JEE server, corresponding EAR project has to be created.

For this, check the “Add project to an EAR “checkbox as above and specify suitable name in “EAR project name “based on the

WAR project name.

Click Finish to create both WAR and EAR projects.

Expand the WAR project.

At this point you will notice errors in the project. To remove these errors follow the next step.

3. Adding the required JAR file to remove the Errors.

a. Next you need to locate the Jar file “tc~sec~ume~logon~logic_api.jar” on which the WAR file is dependent from the following location:

<drive>\usr\sap\<SID>\J00\j2ee\cluster\apps\sap.com\com.sap.security.core.logon\servlet_jsp\logon_app\root\WEB-INF\lib

Copy the “tc~sec~ume~logon~logic_api.jar” file to the WebContent\WEB-INF\lib folder of the WAR project in NWDS.

b. This Jar file has also to be added in the build path of WAR file.

Right Click the WAR project and select Build Path --> Configure Build Path.

c. Click on Libraries tab.Click on “Add External Jars” and select the JAR file “tc~sec~ume~logon~logic_api.jar” from local system and “Add” to get the following screen:

Once done you will notice that all errors have gone !!

4. Make Changes to Layout

a. Now its time to start making the desired changes to the layout. In our example we are changing the branding image

on the Logon screen. We have copied the image “hearts.jpg” to the folder WebContent\layout

SAP delivered image branding-image-portals.jpg has dimension 290X360 px . If you select a bigger image it will get truncated based on the mentioned dimensions. To change the dimensions you need to edit the element urBrandImage in css file

urBrandImage{overflow:hidden;width:290px;height:360px}

b. After the changes have been made, we need to be sure that WAR project is updated in the EAR project and latest changes are

picked up. For this Right Click on WAR project and select Java EE Tools -->Update EAR Libraries.

5. Configuring deployment descriptors

Next we need to configure 2 deployment descriptors of the EAR application as below:

a. application-j2ee-engine.xml

b. application.xml

a. Configuring application-j2ee-engine.xml

In the EAR, view the General tab of the file <project_name>/EARContent/META-INF/application-j2ee-engine.xml.

i. Enter a provider name for your application.This is usually domain name of the client.

The provider name defines your namespace where your applications reside on the AS Java.

If you enter “example.com”, the application deploys to the following path:<ASJava_Installation>/j2ee/cluster/apps/example.com/<project_name>

ii . Next we need to add reference to the standard application com.sap.security.core.logon

Choose References and choose + with the quick info text Add element

iii. Choose Create new and enter the required data.

Reference Data for the Logon Application

Field Name	Data
Reference target	com.sap.security.core.logon
Reference type	hard
Reference target type	application
Provider name	sap.com

This will generate the XML in background which can be displayed in the SOURCE tab :

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<application-j2ee-engine

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="application-j2ee-engine.xsd">

<reference

reference-type="hard">

<reference-target

provider-name="sap.com"

target-type="application">com.sap.security.core.logon</reference-target>

</reference>

<provider-name>newLogon.com</provider-name>

</application-j2ee-engine>

b.. Configuring application.xml

In the EAR, edit the file <project_name>/EARContent/META-INF/application.xml, and define the URL alias and for your custom logon UI.

Double click on application.xml and go to Modules tab . Select the WAR file and enter the “Context Root” field for example : new_logon

We have to provide this alias name later in NWA so please make a note of it.

6. Creating the deployable EAR file

Next we need to create a deployable EAR file . For this right Click on EAR project and select Export -->SAP EAR file

7. Deploying the EAR file

Right click on the EAR project and select Run As --> Run on server

Enter the credentials of the server and file will get deployed on the server with a success message.

You might get an Error screen in NWDS after deployment as below however you can ignore it.

8. Configuring UME properties in NWA

Navigate to the following URL to modify UME properties through Netweaver Administrator

http://<host>:<port>/nwa/auth

a. Change the property Alias of the aplication for customizing login pages (ume.logon.application.ui_resources_alias)

to custom application “ new_logon” which we mentioned previously in the Context root of application.xml

b. Change the property Path or URL to the branding image (ume.logon.branding_image) to “layout/hearts.jpg”

Hurray!!! We have successfully customized the Logon Screen …

9. Next aim is to have a custom text or Notice on the logon page.

Please add the following code after line 44 in the logon.jsp.

<tr>

Notice for All Users

Paste your content here.

</td>

</tr>

Save the new values and restart the portal server.

This finishes (or rather begins) our journey with the customization of Logon page …. !!!

http://scn.sap.com/community/netweaver-portal/blog/2012/05/10/customizing-logon-page-on-portal-73?utm_source=twitterfeed&utm_medium=twitter

저작자표시 비영리 동일조건

'Technique > 그외' 카테고리의 다른 글

GKP 진출 국가별 주요 경제 동향(2013년 10월 ~ 12월) (0)	2014.03.14
RSAP, Rook and ERP (0)	2012.07.08
The Benefits of an Integrated Analytics Framework (2)	2011.12.01
Using reCaptcha at SAP Portal 7.3 Logon Page (0)	2011.11.29
New Memory Analysis Tools for ABAP Web Dynpro (0)	2011.03.27

Posted by AgnesKim

Technique/SAP HANA2012. 5. 8. 10:42

HANA vs. Exalytics: an Analyst's View

Posted by David Dobrin in Blog on May 6, 2012 10:00:28 PM

Introduction

Some people at SAP have asked me to comment on the "HANA vs. Exalytics" controversy from an analyst's point of view. It's interesting to compare, so I'm happy to go along. In this piece, I'll try to take you through my thinking about the two products. I can see that Vishal Sikka just posted a point-by-point commentary on Oracle's claims, so I won't try to go him one better. Instead, what I'll try to do is make the comparison as simple and non-techie friendly as I can. Note that SAP did not commission this post, nor did it ask to edit it.

Exalytics

To begin with, let's start with something that every analyst knows: Oracle does a lot of what in the retail trade are called "knockoffs."

They think this is good business, and I think they're right. The pattern is simple. When someone creates a product and proves a market, Oracle (or, for that matter, SAP) creates a quite similar product. So, when VMWare (and others) prove Vsphere, Oracle creates Oracle VM; when Red Hat builds a business model around Linux, Oracle creates "Oracle Linux with Unbreakable Enterprise Kernel."

We analysts know this because it's good business for us, too. The knockoffs--oh, let's be kind and call them OFPs for "Oracle Followon Products"--are usually feature-compatible with the originals, but have something, some edge, which (Oracle claims) makes them better.

People get confused by these claims, and sometimes, when they get confused, they call us.

Like any analyst, I've gotten some of these calls, and I've looked at a couple of the OFPs in detail. Going in, I usually expect that Oracle is offering pretty much what you see at Penneys or Target, an acceptable substitute for people who don't want to or can't pay a premium, want to limit the number of vendors they work with, aren't placing great demands on the product, etc., etc.

I think this, because it's what one would expect in any market. After all, if you buy an umbrella from a sidewalk vendor when it starts to rain, you're happy to get it, it's a good thing, and it's serviceable, but you don't expect it to last through the ages.

Admittedly, software is much more confusing than umbrellas. With a $3 umbrella, you know what you're getting. With an OFP (or a follow-on product from any company), you don't necessarily know what you're getting. Maybe the new product is a significant improvement over what's gone before. If the software industry were as transparent as the sidewalk umbrella industry, maybe it would be clear. But as it is, you have to dig down pretty deep to figure it all out. And then you may still be in trouble, because when you get "down in the weeds," as my customers have sometimes accused me of being, you might be right, but you might also fail to be persuasive.

Which brings me to the current controversy. To me, it has a familiar ring. SAP releases HANA, an in-memory database appliance. Now Oracle has released Exalytics, an in-memory database appliance. And I'm getting phone calls.

HANA: the Features that Matter

I'm going to try to walk you through the differences here, while avoiding getting down in the weeds. This is going to involve some analogies, as you'll see. If you find these unpersuasive, feel free to contact me.

To do this, I'm going to have to step back from phrases like "in-memory" and "analytics," because now both SAP and Oracle are using this language. I'll look instead at the underlying problem that "in-memory" and "analytics" are trying to solve.

This problem is really a pair of problems. Problem 1. The traditional row-oriented database is great at getting data in, not so good at getting data out. Problem 2. The various "analytics databases," which were designed to solve Problem 1--including, but not limited to the column-oriented database that SAP uses--are great at getting data out, not so good at getting data in.

What you'd really like is a column-oriented (analytics) database that is good at getting data in, or else a row-oriented database that is good at getting data out.

HANA addresses this problem in a really interesting way. It is a database that can be treated as either row-oriented or column-oriented. (There is literally a software switch that you can throw.) So, if you want to do the very fast and flexible analytic reporting that column-oriented databases are designed to do, you throw the switch and run the reports. And if you want to do the transaction processing that row-oriented databases are designed to do, you throw the switch back.

Underneath, it's the same data; what the switch throws is your mode of access to it.

In extolling this to me, my old analyst colleague, Adam Thier, now an executive at SAP, said, "In effect, it's a trans-analytic database." (This is, I'm sure, not official SAP speak. But it works for me.) How do they make the database "trans-analytic?" Well, this is where you get down into the weeds pretty quickly. Effectively, they use the in-memory capabilities to do the caching and reindexing much more quickly than would have been possible before memory prices fell.

There's one other big problem that the in-memory processing solves. In traditional SQL databases, the only kind of operation you can perform is a SQL operation, which is basically going to be manipulation of rows and fields in rows. The problem with this is that sometimes you'd like to perform statistical functions on the data: do a regression analysis, etc., etc. In a traditional database, though, you're kind of stymied; statistical analysis in a SQL database is complicated and difficult.

In HANA, "business functions" (what marketers call statistical analysis routines) are built into the database. So if you want to do a forecast, you can just run the appropriate statistical function. It's nowhere near as cumbersome as it would be in a pure SQL database. And it's very, very fast; I have personally seen performance improvements of three orders of magnitude.

Exalytics: the Features that Matter

Now when I point out that HANA is both row-oriented (for transactions) and column-oriented (so that it can be a good analytics database) and then I point out that it has business functions built-in, I am not yet making any claim about the relative merits of HANA and Exalytics.

Why? Well, it turns out that Exalytics, too, lets you enter data into a row-oriented database and allows you to do reporting on the data from an analytics database. And in Exalytics, too, you have a business function library.

But the way it's done is different.

In Exalytics, the transactional, row-oriented capabilities come from an in-memory database (the old TimesTen product that Oracle bought a little more than a decade ago). The analytics capabilities come from Essbase (which Oracle bought about 5 years ago), and the business function library is an implementation of the open-source R statistical programming language.

So what, Oracle would argue. It has the features that matter. And, Oracle would argue, it also has an edge, something that makes this combination of databases clearly better. What makes it better, according to Oracle? In Exalytics, you're getting databases and function libraries that are tested, tried, and true. TimesTen has been at the heart of Salesforce.com since its inception. Essbase is at the heart of Hyperion, which is used by much of the Global 2000. And R is used at every university in the country.

Confused? Well, you should be. That's when you call the analyst.

HANA vs. Exalytics

So what is the difference between the two, and does it matter? If you are a really serious database dweeb, you'll catch it right away:

In HANA, all the data is stored in one place. In Exalytics, the data is stored in different places.

So, in HANA, if you want to report on data, you throw a switch. In Exalytics, you extract the data from the Times10 database, transform it, and load it into the Essbase database. In HANA, if you want to run a statistical program and store the results, you run the program and store the results. In Exalytics, you extract the data from, say, Times10, push it into an area where R can operate on it, run the program, then push the data back into Times10.

So why is that a big deal? Again, if you're a database dweeb, you just kind of get it. (In doing research for this article, I asked one of those dweeb types about this, and I got your basic shrug-and-roll-of-eye.)

I'm not that quick. But I think I sort of get what their objection is. Moving data takes time. Since the databases involved are not perfectly compatible, one needs to transform the data as well as move it. (Essbase, notoriously, doesn't handle special characters, or at least didn't use to.) Because it's different data in each database, one has to manage the timing, and one has to manage the versions. When you're moving really massive amounts of data around (multi-terabytes), you have to worry about space. (The 1TB Exalytics machine only has 300 GB of actual memory space, I believe.)

One thing you can say for Oracle. They understand these objections, and in their marketing literature, they do what they can to deprecate them. "Exalytics," Oracle says, "has Infiniband pipes" that presumably make data flow quickly between the databases, and "unified management tools," that presumably allow you to keep track of the data. Yes, there may be some issues related to having to move the data around. But Oracle tries to focus you on the "tried and true" argument. You don't need to worry about having to move the data between containers, not when each of the containers is so good, so proven, and has so much infrastructure already there, ready to go.

As long as the multiple databases are in one box, it's OK, they're arguing, especially when our (Oracle's) tools are better and more reliable.

Still confused? Not if you're a database dweeb, obviously. Otherwise, I can see that you might be. And I can even imagine that you're a little irritated. "Here this article has been going on for several hundred lines," I can hear you saying, "and you still haven't explained the differences in a way that's easy to understand."

HANA: the Design Idea

So how can you think of HANA vs. Exalytics in a way that makes the difference between all-in-one-place and all-in-one-box-with-Infiniband-pipes-connecting-stuff completely clear? It seems to me, the right way, is to look at the design idea that's operating in each.

Here, I think, there is a very clear difference. In TimesTen or Essbase or other traditional databases, the design idea is roughly as follows: if you want to process data, move it inside engines designed for that kind of processing. Yes, there's a cost. You might have to do some processing to get the data in, and it take some time. But those costs are minor, because once you get it into the container, you get a whole lot of processing that you just couldn't get otherwise.

This is a very normal, common design idea. You saw much the same idea operating in the power tools I used one summer about forty years ago, when I was helping out a carpenter. His tools were big and expensive and powerful--drill presses and table saws and such like--and they were all the sort of thing where you brought the work to the tool. So if you were building, say, a kitchen, you'd do measuring at the site, then go back to the shop and make what you needed.

In HANA, there's a different design idea: Don't move the data. Do the work where the data is. In a sense, it's very much the same idea that now operates in modern carpentry. Today, the son of the guy I worked for drives up in a truck, unloads a portable table saw and a battery-powered drill, and does everything on site and it's all easier, more convenient, more flexible, and more reliable.

So why is bringing the tools to the site so much better in the case of data processing (as well as carpentry?) Well, you get more flexibility in what you do and you get to do it a lot faster.

To show you what I mean, let me give you an example. I'll start with a demo I saw a couple of years ago of a relatively light-weight in-memory BI tool.

The salesperson/demo guy was pretty dweeby, and he traveled a lot. So he had downloaded all the wait times at every security gate in every airport in America from the TSA web site. In the demo, he'd say, "Let's say you're in a cab. You can fire up the database and a graph of the wait-times at each security checkpoint. So now you can tell which checkpoint to get out at."

The idea was great, and so were the visualization tools. But at the end of the day, there were definite limitations to what he was doing. Because the system is basically just drawing data out of the database, using SQL, all he was getting was a list of wait times, which were a little difficult to deal with. What one would really want is the probability that a delay would occur at each of the checkpoints, based on time of day and a couple of other things. But that wasn't available, not from this system, not in a cab.

Perhaps even worse, he wasn't really working with real-time data. If you're sitting in the cab, what you really want to be working with is recent data, but he didn't have that data; his system couldn't really handle an RSS feed.

Now, consider what HANA's far more extensive capabilities do for that example. First of all, in HANA, data can be imported pretty much continuously. So if he had an RSS feed going, he could be sure the database was up-to-date. Second, in HANA, he could use the business functions to do some statistical analysis of the gate delay times. So instead of columns of times, he could get a single, simple output containing the probability of a delay at each checkpoint. He can do everything he might want to do in one place. And this gives him better and more reliable information.

So What Makes It Better?

Bear with me. The core difference between HANA and Exalytics is that in HANA, all the data is in one place. Is that a material difference? Well, to some people it will be; to some people, it won't be. As an analyst, I get to hold off and say, "We'll see."

Thus far, though, I think the indications are that it is material. Here's why.

When I see a new design idea--and I think it's safe to say that HANA embodies one of those--I like to apply two tests. Is it simplifying? And is it fruitful?

Back when I was teaching, I used to illustrate this test with the following story:

A hundred years ago or so, cars didn't have batteries or electrical systems. Each of the things now done by the electrical system were thought of as entirely separate functions that were performed in entirely different ways. To start the car, you used a hand crank. To illuminate the road in front of the car, you used oil lanterns mounted where the car lights are now.

Then along came a new design idea: batteries and wires. This idea passed both tests with flying colors. It was simplifying. You could do lots of different things (starting the car, lighting up the road) with the same apparatus, in an easier and more straightforward way (starting the car or operating the lights from the dashboard). But it was also fruitful. Once you had electricity, you could do entirely new things with that same idea, like power a heater motor or operate automatic door locks.

So what about HANA? Simplifying and fruitful? Well, let's try to compare it with Exalytics. Simplifying? Admittedly, it's a little mind-bending to be thinking about both rows and columns at the same time. But when you think about how much simpler it is conceptually to have all the data in one database and think about the complications involved when you have to move data to a new area in order to do other operations on it, it certainly seems simplifying.

And fruitful?

Believe it or not, it took me a while to figure this one out, but Exalytics really helped me along. The "Aha!" came when I started comparing the business function library in HANA to the "Advanced Visualization" that Oracle was providing. When it came to statistics, they were pretty much one-to-one; the HANA developers very self-consciously tried to incorporate the in-database equivalents of the standard statistical functions, and Oracle very self-consciously gave you access to the R function library.

But the business function library also does…ta da…business functions, things like depreciation or a year-on-year calculation. Advanced Visualization doesn't.

This is important not because HANA's business function library has more features than R, but because HANA is using the same design idea (the Business Function Library) to enrich various kinds of database capabilities. On the analytics side, they're using the statistical functions to enrich analytics capabilities. On the transaction side, they're using the depreciation calculations to enrich the transaction capabilities. For either, they're using the same basic enrichment mechanism.

And that's what Oracle would find hard to match, I think. Sure, they can write depreciation calculation functionality; they've been doing that for years. But to have that work seamlessly with the Times10 database, my guess is that they'd have to create a new data storage area in Exalytics, with new pipes and changes in the management tools.

Will HANA Have Legs?

So what happens when you have two competing design ideas and one is simpler and more fruitful than the other?

Let me return to my automobile analogy.

Put yourself back a hundred years or so and imagine that some automobile manufacturer or other, caught short by a car with a new electrical system, decides to come to market ASAP with a beautiful hand-made car that does everything that new battery car does, only with proven technology. It has crisp, brass oil lanterns, mahogany cranks, and a picture of a smiling chauffeur standing next to the car in the magazine ad.

The subtext of the ad is roughly as follows. "Why would you want a whole new system, with lots and lots of brand-new failure points, when we have everything they have. Look, they've got light; we've got light, but ours is reliable and proven. They've got a starter; we've got a starter, but ours is beautiful, reliable, and proven, one that any chauffeur can operate."

I can see that people might well believe them, at least for a while. But at some point, everybody figures out that the guys with the electrical system have the right design idea. Maybe it happens when the next version comes out with a heater motor and an interior light. Maybe it happens when you realize that the chauffeur has gone the way of the farrier. But whenever it happens, you realize that the oil lantern and the crank will eventually fall by the wayside.

About David Dobrin

I run a small analyst firm that in Cambridge, Massachusetts that does strategy consulting in most areas of enterprise applications. I am not a database expert, but for the past year, I have been doing a lot of work with SAP related to HANA, so I'm reasonably familiar with it. I don't work with Oracle, but I know a fair amount about both the Times 10 database and the Essbase database, because I covered both Salesforce (which uses Times 10) and Hyperion (Essbase) for many years.

SAP is a current customer of B2B Analysts, Inc., the firm I run.

https://www.experiencesaphana.com/community/blogs/blog/2012/05/06/hana-vs-exalytics-an-analysts-view

저작자표시 비영리 동일조건

'Technique > SAP HANA' 카테고리의 다른 글

HANA is a great way to waste a lot of money (0)	2012.05.17
BWA, Exalytics and SAP-HANA (0)	2012.05.11
SAP HANA SQL for bizy geeks: Episode #1: The importance of being TINY, Data Types and other beasts (0)	2012.05.06
HANA optimized planning with BW-IP (0)	2011.11.29
Dealing with R and HANA (0)	2011.11.29

Posted by AgnesKim

Technique/SAP BO2012. 5. 4. 22:47

Display Hierarchy in WEBi as displayed by BEx query

Posted by Vinay Lohakare in SAP BusinessObjects Web Intelligence on May 4, 2012 3:21:03 PM

Hierarchy layout in WEBI XI3.1 does not come in the same way as in BEx query output.

We do have a drill function in WEBi which will drill the hirerchy from one level to another, but we cannot see all the levels of hierarchies when drilled as we see in the BEx query output.

FOLD/UNFOLD Function:

If we do not want to see the detailed rows in our report we can use the fold/unfold function.When table or break is folded the rows are collapsed and only the header and footers are displayed.

In WEBi XI3.1 we can make use of the FOLD/UNFOLD functionality to get the same hierarchy structure that we see when we run the BEx query.

Note: Tables must have header/footer to be folded and unfolded.

BEx query output:

Below are the steps to achive the same hierarchy layout as we have in BEx.

1) Drag all the level (L00,L01,L02 etc) of hierarchy and the required measures in the WEBi query.

2) Apply break on the dimension object (L00 and L01 dimension objects i.e. the first and second level of hierarchy as we have 3 levels in the current example) on which the hierarchy is to be created(break is not applied in the last level i.e. L02).

3) Drag the measure in the rows, the measure value will be summed up for L00 and L01, if not then sum the measures value at each break.

4) Enable the Fold/Unfold function as shown in the below figure.

As you can see that the measure value for L01 (India) is the 106 which is the sum of measure value for L01 (Maharashtra(6),Goa(68) and Punjab(32)). Similarly for L01 the measure value will be sum of the measure value for L02 object. We have the L00, L01 and L02 dimension objects draged in the report and have hidden the border of the columns to make the hierarchy structure look the same as we have in BEx.

Note: The above solution cannot be implemented if we have more then one hierarchy displayed in the report.

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2012/05/04/hierarchy-in-webi-as-displayed-by-bex-query?utm_source=twitterfeed&utm_medium=twitter

저작자표시 비영리 동일조건

'Technique > SAP BO' 카테고리의 다른 글

Some limitation in Web Intelligence when using directly with BEX Query(BICS in BI 4.0) (0)	2012.06.15
Using SAP HANA Variables with SAP BusinessObjects BI4.0 (0)	2012.05.06
SAP BO : Respond More Quickly to Events Using Real-Time Dashboards (0)	2011.11.25
Handling Hierarchy Authorizations in SAP BEx BO Integration (0)	2011.11.25
SAP Dashboard BI 4.0 Feature Pack 3 Planned Features ASUG Webcast Summary (0)	2011.11.25

Posted by AgnesKim

Technique/SAP BW2011. 12. 8. 09:05

All You Need to Know about HybridProvider in BW 7.30

Rakesh Kalyankar Article (PDF 1 MB) 14 November 2011

Overview

The paper provides a detailed description about the following aspects of hybrid providers: - Purpose - Use-cases - Metadata - Modeling - Usage - Technical details

View this Article

저작자표시 비영리 동일조건

'Technique > SAP BW' 카테고리의 다른 글

Version management in SAP BW 7.3 (0)	2012.04.20
Queries/Workbooks a user can access (0)	2012.04.20
Passing query parameters in background to a BEx report deployed in Enterprise portal (0)	2011.11.29
Time desync of data loading from data source - 0CSM_CASE_ATTR (0)	2011.11.29
Tuning of BWA – FEMS compression (0)	2011.11.28

Posted by AgnesKim

Technique/SAP EPM2011. 11. 29. 13:39

Enterprise Performance Management How-to Guides

* PLEASE NOTE: Any functionality demonstrated in a How-to Guide has not been formally tested by SAP, and therefore, is NOT an officially supported part of the product. If you have any questions on a How-to Guide, or find any potential issues, please do not create a message in OSS - Support will not take questions on How-To-Guides. Instead, please post your question to the EPM forum on SDN, and any questions will be answered there.

Disclosure Management

Content coming soon.

Spend Performance Management

How To... Setup Authorization in Spend Performance Management (PDF 547 KB)

Like all application Spend Performance Management application has information which needs to be based on data level security. Specific users or group of users should only be allowed to access data related to their Source System or Cost Center.

Strategy Management

How to Change and Customize Terminology (PDF 224 KB)

This document describes how to change the SAP Strategy Management user interface terminology to conform to your SAP Strategy Management implementation. The customizations described in this document are for your entire SAP Strategy Management community.

How to Translate the User Interface Into Additional Languages (PDF 257 KB)

The SAP Strategy Management 2007 product installation includes user interfaces in English, French and German, Spanish and Portuguese. This document explains how to set up and translate the SAP Strategy Management 2007 user interface to run in a language other than these languages.

How to Manage the Entry and Approval Process (PDF 877 KB)

This How-To guide covers the data entry and approval process for SAP Strategy Management (SSM), considerations in the data collection approach, and issues around the implementation and management of the entry and approval process.

How To Create a PAS Model in Cube Builder (PDF 22 KB)

This is documentation that allows savvy business-users to create simple PAS models in Strategy Management 7.0 using the HTML Cube Buildier. Cube Builder is avaiable at the Service Marketplace in Note #1156272.

How-to Customize Strategy Management 7.0 (PDF 1294 MB)

This document discusses modifications a consultant may make to SAP Strategy Management 7.0 and how to transport these modifications from a development environment to an SSM QA and/or an SSM Production environment. This document reviews examples of customizations made to SSM.

How-to load SAP Netweaver BW data into SAP BusinessObjects Strategy Management (PDF 149 MB)

With SAP BusinessObjects Strategy Management 7.X, customers have the opportunity to leverage any prior investments in SAP BW and bring SAP NetWeaver BW data to their SSM implementation.

Profitability and Cost Management

How To bring SAP BusinessObjects Profitability and Cost Management (PCM) Result Table Data to SAP NetWeaver BW using DB Connect (PDF 371 KB)

Customers who have implemented PCM alongside an SAP BW installation may want to bring the PCM result data back to SAP BW to ensure that BW remains the single unified version of the truth in the organization.

How to Generate Product and Customer Data Views using Planning and Consolidation, Profitability and Cost Management, and Financial Information Management

(PDF 1 MB)

The objective of this guide is to provide an understanding of the mechanisms for transferring transactional data from SAP BusinessObjects Planning and Consolidation (BPC) into SAP BusinessObjects Profitability and Cost Management (PCM) using SAP BusinessObjects Financial Information Management (F.I.M.). Once data is successfully transferred into the PCM application allocations are processed to provide additional Customer and Product data segmentation.

Financial Consolidation

Working languages in SAP BusinessObjects Financial Consolidation 7.5 (PDF 625 KB)

The main objective of this "How To Guide" is to give some recommendations for FC 7.5 to the consultant who wants to install and to implement FC 7.5. This presentation is based on the feedback from our Ramp-Up customer LUKOIL which used Russian language and changed the languages in the defaultlanguages.xml for the database pre-initialization step before the migration step.

Business Planning and Consolidation, version for the Microsoft Platform

BPC 5.x

How to Build SSIS Packages for BPC 5.0 (PDF 1011 KB)

This how-to guide covers the baseline principle of setting up a SAP BPC 5.0 data manager package using SSIS in SQL 2005.

How to Backup and Restore with SAP BPC 5x (SQL 2005) (PDF 845 KB)

This guide shows the typical backup and restore procedures for SAP BPC 5.1 on top of Microsoft SQL Server 2005.

How to Backup and Restore with SAP BPC 5x (SQL 2000) (PDF 267 KB)

This guide shows the typical backup and restore procedures for SAP BPC 5.1 on top of Microsoft SQL Server 2000.

How to Use MDX Dimension Formulas Article (PDF 451 KB)

In SQL 2000, AS does not recognize the separate dimensions as a single dimension when considering dimension formulas. In SQL 2005, AS does recognize the separation as a single dimension but consider formulas by hierarchy. These differences have created the need for this document.

How to Manage Data with BPC 5.x with Data Manager Tools (PDF 992 KB)

This How-To demonstrates how to leverage the data manager tools within BPC and perform tasks such as uploading data.

How to Perform a BPC Multi-Server Install (PDF 3310 KB)

This How-To walks you step by step through how to perform a multi server installation for BPC 5.1 on Microsoft SQL Server 2005.

How to Build a Custom Menu for BPC 5.x (PDF 746 KB)

This How-To is an introduction on how to create BPC 5.x Custom Menus.

How to Setup a Security Concept in SAP BPC 5.x (PDF 955 KB)

This How-To is an introduction into the SAP BPC 5.x security model.

How to Maximize Advanced Formatting for BPC 5.x Article (PDF 295 KB)

When implementing BPC for reporting or input of application data, the primary BPC Excel function is EVDRE. In order to maximize the customer and user experience with EVDRE, projects should always identify planned formats for the Reports / Input templates and document this in a framework called a Style Guide. The style guide should outline the expected format options for any and all combinations of data, headers, and blank spaces used in the BPC Reporting framework.

How to Utilize Allocations in SAP BPC 5.x (PDF 297 KB)

BPC Script documentation and features for utilizing the ALLOCATION functionality. This document provides detailed information regarding the logic script syntax and examples to assist in using the tool in applications.

How to Set-Up Intercompany Matching (PDF 858 KB)

How to set-up an intercompany matching application and how to book the resulting intercompany differences.

How to setup Carry forward and Account transformation business rules (PDF 841 KB)

This how-to guide will focus on the fundamentals of building two different Business Rules, the Carry Forward Rule(CopyOpening), and the Account Transformation Rule(CalcAccount). Business Rules provide the mathematical foundation for the BPC application, and allows the clients to manage both management and legal consolidaiton reporting.

How-to run SAP BPC in a VMWare environment (PDF 841 KB)

This How-to guide will focus on the particularities of running SAP Business Planning and Consolidation in a VMware environment.

How-to add comments in BPC (PDF 605 KB)

This How To Use Comments guide focuses on the fundamentals of creating, modifying, reporting and extracting, of the comment functionality within BPC 5.x and BPC 7.0 M.

SAP BPC 5.0 and 5.1 Performance and Reliability tips (PDF 55 KB)

This is short list of hints to solve common performance and reliability issues of SAP Business Performance and Consolidation (aka BPC) 5 and 5.1. Most of them were come from troubleshooting of escalated customers. Since BPC 7 for Microsoft is direct child of 5.1, many of these hints are still valid even under BPC 7 for Microsoft platform.

How to use SSL with BPC (PDF 186 KB)

This how-to guide provides best practices for configuring SSL with BPC

How-to partition in SSAC for BPC 5.X (PDF 462 KB)

In order to improve Performance, please use this how-to guide to create partitioning.

How-To Use the SAP BusinessObjects Planning and Consolidation(BPC) Toolkit for LoadRunner (PDF 1,161 KB)

This How-To guide consists of a utility named the BPC LoadRunner Toolkit and a How-To guide describing how to use the toolkit. The application currently contains three components: one that assists in script recording and two that support user parameterization.

How To Plan and Execute LoadRunner Scenarios for SAP BusinessObjects Planning and Consolidation (PDF 2,071 KB)

This How-To guide provides guidance and suggestions for using HP LoadRunner with SAP BusinessObjects Planning and Consolidation. It covers all topics from planning a scenario to recording LoadRunner scripts, and finally analyzing the results.

BPC 7.0 (MS)

How to Use BPC Business Process Flows Services within Xcelsius (PDF 1 MB)

This guide shows how to display "SAP Business Objects Planning and Consolidations 7.0, version for the Microsoft Platform" BPF information within the Xcelsius tool.

How to Use BPC MS Data within Xcelsius (PDF 4 MB)

This guide shows how to use data from "SAP Business Objects Planning and Consolidations 7.0, version for the Microsoft Platform" within the Xcelsius tool.

Usage and Considerations of evDRE in BPC 7.0M (PDF 386 KB)

A guideline to assist any user with reporting best practices using evDRE, a BPC Excel function.

Enabling the BPC 7.0 Management Console (PDF 947 KB)

Documented steps for supporting the installation of the Management Console in the BPC 7M version, in addition to the Installation guide.

How to Utilize Allocations in SAP BPC 5.x (PDF 297 KB)

How to set-up Intercompany Matching (PDF 858 KB)

How to set-up an intercompany matching application and how to book the resulting intercompany differences.

How to Manage BPC and M Time Dimensions and Custom Measures (PDF 940 KB)

The purpose of this guide is designed to support customers who require the addtion of a Multi-Hierarchy Time Dimension, and provides guidance on adding new Measures to the Application set.

How to understand the Management Console (PDF 1473 KB)

This How-to Guide will help you navigate and understand the Management Console available in 7M.

How to do Currency Translation for Financial Application using SAP BPC 7.0 version for Microsoft SQL Server (PDF 410 KB)

This HTG will show how to do the basic setup to efficiently do currency translation for Financial Application using the BPC MS using Business Rule. This will also focus on what the dimension properties and the relevant setting required for creating the Currency translation using the Business Rules tables and script logic using the BPC MS. This will also show how to setup the data package to run the task using the "BPC Excel" Successfully. Please note that this HTG is for running currency translation in reporting currency mode only i.e. for Financial Application. If you want to run currency translation in group mode, there are some extra conditions that are needed. Please refer to the HTG on "How to run Currency translation for Consolidation Application in BPC MS" to see how to run in group mode.

BPC 7.5 (MS)

How To ... Mass Import Security for BPC MS (PDF 1MB)

This guide explains how an admin user or a consultant can import and export security information within SAP Business Objects Planning and Consolidations Microsoft Platform. SAP Business Objects Planning and Consolidations currently provides a wizard support adding or removing a single user at a time. This guide provides a means for mass user maintenance using a SSIS package and a custom task.

Business Planning and Consolidation, version for the SAP NetWeaver Platform

BPC 7.0 (NW)

How To Use the BPC Mass User Management Tool (PDF 1 MB)
This guide will introduce the BPC_NW User Management Tool, which is a custom program which allows mass maintenance of the BPC_NW security objects. These objects include users, teams, team assignments, task profiles, member access profiles, task profile assignments, and finally, member access profile assignments. This custom program uses the BPC_NW user management APIs, the same APIs used by the BPC_NW Admin Console, to correctly create or update the associated security objects.

How to Promote Reports and Input Schedules through your System Landscape (PDF 374 KB)

This how-to guide will demonstrate how to move reports and input schedules to target systems within your system landscape...

How to Use BPC Data Manager to Import Master Data and Transaction Data from 3rd Party Systems via SAP BusinessObjects Data Services (PDF 2 MB)

This guide explains how to use BPC Data Manager to execute BOBJ Data Services Jobs... This is to allow BPC users to use their same user interface, while leverage the power of data services for 3rd party data access...

How to Create Customer measure formulas for Fiscal Periodic, QTD and YTD (PDF 867KB)

Today, within BPC NW, there exist the concept of measure formulas to be used within applications for reporting. This guide will show how to customize these measure formulas and create your own.

How to Create Create Custom Menu within BPC NW (PDF 2 MB)

In this scenario, we will show you how to create custom menu with pre-defined planning processes. We will also explore the supported functionality differences between BPC MS and BPC NW.

How to Link SAP BPC Excel from an Enterprise Portal (PDF 180 KB)

This document shows you how to link SAP BPC Excel from an enterprise portal.

How to Automate Master Data Loads in BPC NW (PDF 1 MB)

This How-to guide provides information on how-to automate Master Data loads in BPC 7.0 NW.

How to Run a Top Down Allocation within BPC NW (PDF 2 MB)

In this scenario, we will show how to do a top down allocation in BPC NW.

How to Pass parameters to custom logic BADI using START_BADI (PDF 2.07 MB)

In this scenario, we will pass parameters to ABAP custom logic using START_BADI statements within Script Logic. As an example, we will be implementing Declining Depreciation function (Similar to DECD keyword from FOX) using BADI implementation.

How to Pass Dynamically Parameters to Script Logic from Data Manager (PDF 1.2 MB)

In this scenario, we will try to pass runtime parameters (called "prompts") from data
manager to script logic.

How to Use BPC NW Data within Xcelsius (PDF 3 MB)

This guide shows how to use data from "SAP Business Objects Planning and Consolidations 7.0, version for SAP NetWeaver" within the Xcelsius tool.

Data Modeling Considerations for BPC Time Dimensions (PDF 191 KB)

This paper discussed a methodology to align BI and BPC data models. The time data format issues are discussed and a technical solution is proposed.

How to apply SP1 to BPC 7.0 (PDF 698 KB)

This guide describes in a step-by-step approach how to apply SP01 to SAP BPC 7.0 NW.

How to apply SP2 to BPC 7.0 (PDF 820 KB)

This guide describes in a step-by-step approach how to apply SP02 to SAP BPC 7.0 NW.

How to Export BPC Transaction Data Using a Custom Process Chain (PDF 991 KB)

This guide describes in a step-by-step approach how to create a custom process type for exporting BPC transaction data to a flat file.

How-to Set-Up Extraction of Balances for BPC NW 7.0 (PDF 649 KB)

This document describes how to set up extraction of balances from SAP ECC 6.0 system (transaction system) for the purpose of consolidation in SAP BPC 7.0 NW system.

How to Create a Custom BPC Process Chain (PDF 1.27 MB)

This guide provides a how to for creating Custom BPC Processes.

How-to Desitnation App (PDF 820 kB)
Transport for How-to Guide (Transport )

This guide provides the step by step instructions for creating and the use of a custom BADI that replicates the full functionality of the SAP BusinessObjects Planning and Consolidation process "Destination_App". Numerous script logic examples as well as extensive error messaging explanations are provided.

How To Use COPYOPENING using SAP BusinessObjects Planning and Consolidation for the SAP NetWeaver Platform*(PDF 245 KB)

This document describes how to set up Balance Carry Forward using the COPYOPENING script with SAP BusinessObjects Planning and Consolidation(BPC) 7.0 for the SAP NetWeaver platform.

How to do Currency Translation for Financial Application using SAP BusinessObjects Planning and Consolidation 7.0 for the SAP NetWeaver Platform (PDF 358 KB)

This document describes how to set Currency Translation for Financial application with SAP BusinessObjects Planning and Consolidation for the 7.0 SAP NetWeaver BI based version.

How to Email a Data Manager Package Log to a Team (PDF 689 KB)

This guide describes in a step-by-step approach how to use the "Email Team" process type to email data manager package logs to a team.

How To...Custom BADI for rounding off values in SAP BUSINESSOBJECTS Planning and Consolidation, version for SAP NetWeaver (PDF 125 KB)

This guide provides the step by step instructions for creating and the use of a custom BADI that rounds off the value as per the decimals specified by the user in parameters. Numerous script logic examples as well as extensive error messaging explanations are provided.

How to do Breakdown Validation in SAP BPC 7.0 for the SAP NetWeaver Platform (PDF 433 KB)
This HTG will show how to do the basic setup to efficiently do breakdown validations in BPC NW. This will also focus on what the dimension properties and the relevant backend setting required for creating the backend validations in the SAP NetWeaver system. This validation will ensure that only valid records are written to the cube during write back.

How To Setup a Legal Consolidation Application using SAP BPC 7.0 version for SAP NetWeaver (PDF 1 MB)

This HTG goes through the basic setup of a Legal Consolidation Application in BPC for SAP NetWeaver. Furthermore, it discusses the relevant dimension properties and the setting required for creating the Currency translation, eliminations, and other operations using the Business Rules tables and script logic within BPC in SAP NetWeaver. Please note that this HTG will discuss only the overview of running currency translation, inter unit elimination, balance carry forward etc. For more details please refer to the How To guide for each individual topic.

How To... Mass Delete Data Manager Log Files (PDF 312 KB)

This guide will demonstrate how to mass delete data manager log files based on a retention period.

How To... Use the Shared Query Engine Post Process BAdI (PDF 786 KB)

This guide provides the step by step instructions for the creation and the use of a custom SQE BADI that implements matrix or intersectional security.

How To... Use the Write Back Pre-Process BAdI (PDF 957 KB)

This guide provides the step by step instructions for the creation and the use of a custom BADI for writing to a parent level in the write back module of BPC.

How To... Move data between applications using Data Manager Package in SAP BPC 7.0 NW (PDF 418 KB)

This document describes how we can achieve Copy between Applications in an Appset and also how to implement it as a re-usable package.

How to Implement Load Balancing on SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver (PDF 477 KB)

This guide will show you how to implement Load Balancing in BPC NW 7.0 and 7.5, both at the application server level and at the .Net server level. The guide also describes various options for Load Balancing, including their benefits and limitations.

BPC 7.5 (NW)

How To... configure and execute Business Process Flows in SAP BusinessObjects Planning and Consolidation 7.5 version for SAP NetWeaver (PDF 1024 KB)

This how-to guide provides step by step instruction to configure and execute Business Process Flows in SAP BusinessObjects Planning and Consolidation 7.5 version for SAP NetWeaver

How To... Import Master Data and Hierarchies into SAP BusinessObjects BPC 7.5 from SAP NetWeaver BW (PDF 967 KB) *UPDATED*

This How-to Guide demonstrates how to use new process chains introduced in SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver to transfer master data and hierarchies from SAP NetWeaver Business Warehouse using the Planning and Consolidation Data Manager. It focuses on how to handle three common design approaches, any of which, you may encounter when integrating Cost Center master data into BPC. Please refer to the new related SAP Notes section which addresses many of the issues customers have encountered when trying to implement this scenario.

How To... Use the Start and End Routine BAdIs (PDF 1 MB)

This guide provides the step by step instructions for the creation and the use of the Start Routine and End Routine BAdI functionality within Data Manager transformation files.

How To... Use the BPC Mass User Management Tool (PDF 1 MB)

This guide will introduce the BPC NW User Management Tool, which is a custom program which allows mass maintenance of the BPC_NW security objects.

(Whitepaper) Life Cycle Management in SBOP Planning and Consolidation version for Netweaver (PDF 565 KB)
This white paper covers the main aspects that should be considered while defining a transport strategy for SBOP Planning and Consolidation version for Netweaver. Areas addressed include: the transport mechanism, transport tools, and approaches for managing changes in the specific context of Netweaver.

How To... Retract data from BPC 7.5 NetWeaver to SAP ERP Cost Center Accounting, Part I (PDF 3 MB)

This guide provides the step by step instructions for the creation and the use of a custom BPC 7.5 NW Retraction BAdI that retracts data to SAP ERP Cost Center Accounting. A business example is provided as well as all the necessary steps to get this example working in your system.

How To..Configure Drill Through Functionality (PDF 3 MB)

This guide provides the step by step instructions for configuring Drill Through in BPC.

How To...Write to secured dimension members in default logic (PDF 583 KB)
SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver, performs standard security checks on data that is created during the execution of default logic. This guide provides a step by step process on how to allow default logic to write data containing dimension members for which the calling user may not have security access.

How...To Get Consistent Results with UJ_CUSTOM_LOGIC BADIs (PDF 1 MB)

This How-To guide provides a consistent solution on the different ways Input Schedule and Data Manager logic are executed. An ABAP class is provided that can be included in all BAdi implementations. It checks the source of data submitted to the BAdi, and if it originated from an Input Schedule it reverses the signs for INC/LEQ accounts and returns the updated “SIGNED DATA” in a new standard table. Otherwise, it will return the original, unaltered records in a new standard table. This HTG also includes an example BAdi implementation based on the delivered Apshell application set.

How to Implement Load Balancing on SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver (PDF 477 KB)

How To - Implement the RUNLOGIC Keyword in SAP Business Objects Planning and Consolidation, version for NetWeaver (PDF 1.5 MB) *NEW*

This guide will show you how to implement the BPC NW version of the script logic Keyword RUNLOGIC. Using a script logic BAdI, the new BPC NW version of RUNLOGIC will not only mimic the BPC MS functionality, but also allow you to improve the performance of individual scripts. This valuable performance improvement is achieved by executing separate scripts in parallel using distinct data sets. The guide will show you how to call the new Keyword as well as configure the data sets and processes for parallel execution.

How To… Use the EPM Connector to Visualize SAP BusinessObjects Planning and Consolidation (BPC) Data via SAP Crystal Dashboard Design (Xcelsius) (PDF 3 MB) *NEW*

This how-to guide explains the steps to visualize BPC data using SAP Crystal Dashboard Design(formerly Xcelsius). In this guide, you will learn how to use SAP BusinessObjects Extended Analytics to build a report, and the SAP BusinessObjects EPM Connector to enhance the functionality of your dashboard.

Whitepaper: Script Logic Primer - Planning and Consolidation Version for Netweaver (PDF 1 MB) *UPDATED May 2011*

This whitepaper provides in depth information on how to implement script logic within SAP BusinessObjects Planning and Consolidation 7.x version for Netweaver. Keywords are discussed and numerous examples are provided to make the complex topics easily understandable.

How to… Setting up Matrix Consolidation with SAP BusinessObjects Planning and Consolidation (PDF 577 KB) *NEW*

Matrix Consolidation refers to Consolidation where not only the usual Legal entity dimension is used but an additional dimension, such as Profit/Cost Center or Business Unit is required. It is not only used for performing some breakdown analysis, but eliminations must be performed based on this alternate dimension. This document describes how to set up Matrix Consolidation. As a starting point, the IFRS Starter Kit application set was used. It is available for downloads on the SAP Service Marketplace. Limitations to the approach are presented.

How to... Configure the Balance Carry Forward Business Rules for SAP BusinessObjects Planning and Consolidation 7.5, version for Netweaver (PDF 417 KB) *NEW*

Balance Carry Forward (BCF) business rules allow business users to define how closing balances from selected financial accounts are copied (carried over) into the opening balances of the next financial period. This guide identifies the options available in the BCF business rule and provides examples to illustrate the functionality.

How to... Configure US Elimination Business Rules for SAP BusinessObjects Planning and Consolidation 7.5, version for Netweaver (PDF 514 KB) *NEW*

The SAP BusinessObjects Planning and Consolidation 7.5, version for Netweaver US Elimination business rules provide the ability to perform intercompany (entity to entity) eliminations functionality where the system automatically identifies and eliminates the impact of inter-company (entity) activities. This guide provides a detailed technical review of the US Elimination configuration as well as in-depth examples illustrating key points.

Improve your Reporting Performance in SAP BusinessObjects Planning and Consolidation Version for NetWeaver (PDF 889 KB) *NEW*

This white paper covers EVDRE performance tips for SBOP Planning and Consolidation version for Netweaver (SBOP PC_NW). Areas addressed include: MDX vs. RSDRI queries, custom suppression, and tips and tricks in developing EVDRE templates.

BPC 10 (NW)

Master Data on the Fly in SAP BusinessObjects Planning and Consolidation 10.0, version for NetWeaver (PDF 943 KB) *NEW*

Traditionally SAP BusinessObjects Planning and Consolidation 10, version for SAP NetWeaver, administrators maintain dimensions and their members in the BPC Administration Web client to ensure governance and consistency of master data. However under certain circumstances, it may be necessary to allow end users to create master data values themselves “on the fly” rather than having to wait for a central administrator to do it for them.

How to … Configure Ownership Manager and Automated Calculations for SAP BusinessObjects Planning and Consolidation 10.0, version for Netweaver (PDF 542 KB) *NEW*

Ownership Manager now has the ability to calculate proposals for key financial parameters (Consolidation Method to be employed, Consolidation Percent, Percent Control, and Percent Financial Interest). This guide provides a detailed explanation of the technical components of the Ownership Manager’s data model and the key components required for these calculations.

Implementing Client Certificate Authentication in SAP BusinessObjects Planning and Consolidation 10.0, version for NetWeaver (PDF 2 MB) *NEW*

Single Sign On is a topic that is often overlooked until well into an implementation. The purpose of this guide is to provide step by step instructions on implementing SSO via client certificates for BPC 10 for NetWeaver. It can be useful for scenarios where a PKI infrastructure already exists as well as for proof of concepts.

SAP Strategy Management

SSM 7.0

Best Practices: The BI Connector in SSM 7.0 (PDF 190 KB)

This Best Practice Guide for the BI Connector in SSM 7.0 brings together previously undocumented detailed information that was not included in the original BI Connector RKT material as well as lessons learned from the very first customer projects that used the connector. It is current as at SSM 7.0 SP02.

How To Handle Seasonality in KPIs Article (PDF 42 KB KB)

The effects of seasonality to a business affect more than ice cream vendors and skiwear shops! It is an issue that impacts almost every business - from private industry to government. Most obvious impacts are to marketing, staffing, and cash flow. In the context of strategic planning, seasonality is a key consideration when identifying key performance indicators (KPIs) and setting performance targets. The purpose of this document is to provide background on how to handle seasonality with the SAP Strategy Management (SSM) solution.

Building Better Scorecards Using Workflow Based Data Entry Article (PDF 175 KB KB)

While many organizations that have effectively implemented strategy management solutions have a solid infrastructure for uploading KPI data (actual and target values) to build their scorecards, many still struggle with the question of how best to obtain data that does not reside in a transactional data source and therefore must be entered manually by business users. This paper outlines a process and software solution that can be used to develop a secure, repeatable, workflow based methodology for allowing business users to manually enter scorecard data.

SAP BusinessObjects Planning and Consolidation

Blog Wiki NEW

A new wiki is available which lists a wide selection of blogs on the BPC topic.
SAP BusinessObjects Planning and Consolidation Blogs

ToolsNEW

How To... Generate test data for SAP BusinessObjects Planning and Consolidation (PDF 1 MB)

During the test design phase of the software life cycle, with applications such as SAP BusinessObjects Planning and Consolidation (BPC), it can be necessary to generate large volumes of test data to ensure the application will meet the business user’s key performance indicators (KPIs) in a production environment. The BPC DataGenerator tool, included with this How-To Guide, provides one approach to quickly generate test data to import into a BPC application.

Reporting

Best Practices for Reporting within SAP Business Planning and Consolidations 5.0 Article (PDF 267 KB)

This document describes best practices for building SAP BPC 5.0 reports. Before starting with the best practices, some discussion about EvGET and EvDRE might be helpful. EvGET is the original function that was used to retrieve data from the database. To increase performance, an enhanced formula, EvDRE, was developed. For more information about EvDRE, see the WebExcel Help.

Logic

SAP Business Planning and Consolidation Script Logic, Part 1 Presentation, (PDF 200 KB)

If your a user of BPC 5.x you will want to view this presentation to help you learn more about the calculations capabilities of BPC. This function is commonly referred to as "Logic". This is the first of a three part series.

SAP Business Planning and Consolidation Script Logic, Part 2 Presentation, (PDF 211 KB)

SAP Business Planning and Consolidation Script Logic, Part 3 Presentation, (PDF 202 KB)

Performance

Business Planning and Consolidation 5.x Performance Tuning Guide (PDF 458 KB)

This guide is an update to a previously posted document regarding BPC 5.x performance tuning guide.

Microsoft SQL 2005 Database Info Related

Queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005 BUG Report

If you have a customer experiencing slow/degrading database performance on SQL Server 2005, then you might want to look at the bug described in Microsoft Knowledge Base Article 927396. The problem relates to SQL Server spending too much time (and hardware resources) accessing one of its internal caches, called the TokenAndPermUserStore cache.

https://wiki.sdn.sap.com/wiki/display/BPX/Enterprise+Performance+Management+%28EPM%29+How-to+Guides

저작자표시 비영리 동일조건

'Technique > SAP EPM' 카테고리의 다른 글

10 Key Value add from SAP EPM 10 (0)	2011.11.25
Assessing EPM: Rethinking the Traditional ROI Approach (0)	2011.11.25

Posted by AgnesKim

Technique/그외2011. 11. 29. 13:36

Using reCaptcha at SAP Portal 7.3 Logon Page

Using reCaptcha at SAP Portal 7.3 Logon Page
Erhan Keseli
Business Card
Posted on Nov. 28, 2011 05:19 AM in Enterprise Portal (EP)

If you have a portal which exposed to internet, you may want to use captcha for bots. So in this blog I will implement reCaptcha. Why do I choose reCaptcha? Because it is easy to implement and you dont need to implement a lot of things to work. Let's do it!

First you have to modify logon page. You can find it solution here: http://nwturk.com/blog/2011/06/06/changing-logon-page-on-netweaver-7-3/

You have to import jar files of reCaptcha (link). After importing files modify logonPage.jsp file for reCaptcha.

-Import reCaptcha:

<%@ page import="net.tanesha.recaptcha.ReCaptcha" %>
<%@ page import="net.tanesha.recaptcha.ReCaptchaFactory" %>

-Add reCaptcha code for displaying captcha. You can customize it for your need:

<%
	ReCaptcha c = ReCaptchaFactory.newReCaptcha("your public key", "your private key", false);
	out.print(c.createRecaptchaHtml(null, null));
%>

Be careful adding these code block between <sap:form type="logon"></sap:form>

We have done about this part. Now it is time to implement login module. You can get more information about login modules from this link. Now you have more information about login modules after link. Implement the class and add a new method to get response.

	private String getRequestValue(String parameterName)
		throws LoginException {

		HttpGetterCallback httpGetterCallback = new HttpGetterCallback();
		httpGetterCallback.setType(HttpCallback.REQUEST_PARAMETER);
		httpGetterCallback.setName((String) parameterName);

		String value = null;

		try {
			_callbackHandler.handle(new Callback[] { httpGetterCallback });

			String[] arrayRequestparam =
				(String[]) httpGetterCallback.getValue();

			if (_decodeRequestParameter) {
				value = URLDecoder.decode(arrayRequestparam[0], "UTF-8");
			} else {
				value = arrayRequestparam[0];
			}

		} catch (UnsupportedCallbackException e) {

			return null;

		} catch (IOException e) {
			throwUserLoginException(e, LoginExceptionDetails.IO_EXCEPTION);
		}

		return value;
	}

You can call method with these parameters. (example: String challengefield = getRequestValue("recaptcha_challenge_field");

And also you need client ip address. Here is the moethod to get ip address:

	private String getIPAddress(){
		String clientIp = "";
		try{
			HttpGetterCallback hgc = new HttpGetterCallback();
			_callbackHandler.handle(new Callback[] { hgc });
			hgc.setType(HttpCallback.CLIENT_IP);
			clientIp = (String)hgc.getValue();
		}catch(Exception ex){

		}
		return clientIp;
	}

If you have a reverse proxy you get ip address of it. So you have to configure it to get clients ip address.
After you get the parameters for reCaptcha check them:

import net.tanesha.recaptcha.ReCaptchaImpl;
import net.tanesha.recaptcha.ReCaptchaResponse;

ReCaptchaImpl reCaptcha = new ReCaptchaImpl();
reCaptcha.setPrivateKey("your_private_key");
String ipAdress = getIPAddress();
String challenge = getRequestValue("recaptcha_challenge_field");
String uresponse = getRequestValue("recaptcha_response_field");
ReCaptchaResponse reCaptchaResponse = reCaptcha.checkAnswer(ipAdress, challenge, uresponse);
if (reCaptchaResponse.isValid()) {
	// do your valid login work
}else{
    // do your invalid login work
}

Erhan Keseli is an Senior SAP Technical Consultant specialized on Netweaver Technology.

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27537%3Futm_source%3Dtwitterfeed%26utm_medium%3Dtwitter%26utm_campaign%3DFeed%253A+SAPNetworkWeblogs+%2528SAP+Network+Weblogs%2529

저작자표시 비영리 동일조건

'Technique > 그외' 카테고리의 다른 글

Customizing Logon Page on Portal 7.3 (0)	2012.05.10
The Benefits of an Integrated Analytics Framework (2)	2011.12.01
New Memory Analysis Tools for ABAP Web Dynpro (0)	2011.03.27
New Memory Analysis Features in NetWeaver 7.0 EHP2 (0)	2011.03.27
Difference between transactions RS12 / SM12 ? (0)	2011.03.27

Posted by AgnesKim

Technique/SAP BW2011. 11. 29. 13:34

Passing query parameters in background to a BEx report deployed in Enterprise portal

Passing query parameters in background to a BEx report deployed in Enterprise portal
Sriramvijay.R
Business Card
Company: L&T Infotech
Posted on Nov. 27, 2011 06:49 AM in Enterprise Data Warehousing/Business Warehouse, Enterprise Portal (EP)

This blog is a work around to pass query parameters in background to a BEx report deployed in Enterprise portal.

To explain this work around simply, the below scenario is taken as example.

Consider a scenario where there are many customers (Info object 0SOLD_TO). Customer will log into Enterprise portal and run their Account statement Report. The customer’s Login ID (Should be same as customer Key) will be passed as filter value to 0SOLD_TO automatically in background. This will prevent customer from accessing others data.

The following are the step by step instruction to do this work around.

Create the necessary report in BW with 0SOLD_TO in free characteristics.

Create a Web template. For creating Web templates use Web application designer. There will be standard web templates like 0ANALYSIS_PATTERN. Remove unnecessary buttons like filter, Navigation pane, New analysis from that template and save as a new template with a name 0ANALYSIS_PATTERN_1.

Next create an iView of type "BEx Web Application iView" in Enterprise portal.

In the iView give query technical name, Web template technical name as shown in the below screen shot.

To restrict report in background we need a string like the one below.

“BI_COMMAND=&BI_COMMAND-BI_COMMAND_TYPE=SET_SELECTION_STATE&BI_COMMAND-TARGET_DATA_PROVIDER_REF_LIST-TARGET_DATA_PROVIDER_REF=DP_1&BI_COMMAND-CHARACTERISTICS_SELECTIONS=&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1=&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS=&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-ELECTION_1=SELECTION_INPUT_STRING&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1-SELECTION_INPUT_STRING=05A05325&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1CHARACTERISTIC=0SOLD_TO&PAGE_ID=1_elZDdTRmeUY4TUtTc21FQm1GUHhjQS0tMFlHQ01IaTZuczd1bWRTQVZsUks5QS0t&REQUEST_ID=7”

Whenever we restrict a query with a parameter, this kind of string passed in background. There is a work around to get this string. For that you need the following things,

(i) A web template with filter option – to give restriction on characteristic so that string can be captured.

(ii) A Web Debugging Proxy - which logs all HTTP(S) traffic between your computer and the Internet. This will capture the required string in text view.

Change the template name to 0ANALYSIS_PATTERN in iView and execute. Give restriction to query as below.

For this purpose only 0SOLD_TO was kept in free characteristic. After getting the restricted output, go to Web debugging proxy. There you get the string.

Once the string is captured, that can be modified to meet our requirement. The user login ID can be obtained from the command <User.LogonUid>. Replace Restriction parameter value with the command as shown below and remove the PAGE_ID at the end of the string. So the result string will look like this.

“BI_COMMAND=&BI_COMMAND-BI_COMMAND_TYPE=SET_SELECTION_STATE&BI_COMMAND-TARGET_DATA_PROVIDER_REF_LIST-TARGET_DATA_PROVIDER_REF=DP_1&BI_COMMAND-CHARACTERISTICS_SELECTIONS=&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1=&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS=&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-ELECTION_1=SELECTION_INPUT_STRING&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1-SELECTION_INPUT_STRING=<User.LogonUid>&BI_COMMAND-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1CHARACTERISTIC=0SOLD_TO"

This modified string should be added to iView Application parameter as in the below screen shot.

iView HTTP Request method should be set to POST method as in the below screen shot.

Again change the iView name into 0ANALYSIS_PATTERN_1.

Now, when a customer opens the report it will be restricted to his account only.

Sriramvijay.R is a BI/BO Consultant working in L&T Infotech, India

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27503%3Futm_source%3Dtwitterfeed%26utm_medium%3Dtwitter%26utm_campaign%3DFeed%253A+SAPNetworkWeblogs+%2528SAP+Network+Weblogs%2529

저작자표시 비영리 동일조건

'Technique > SAP BW' 카테고리의 다른 글

Queries/Workbooks a user can access (0)	2012.04.20
All You Need to Know about HybridProvider in BW 7.30 (0)	2011.12.08
Time desync of data loading from data source - 0CSM_CASE_ATTR (0)	2011.11.29
Tuning of BWA – FEMS compression (0)	2011.11.28
Functional Module Based Delta Enabled Generic Datasource (0)	2011.11.25

Posted by AgnesKim

Technique/SAP HANA2011. 11. 29. 13:33

HANA optimized planning with BW-IP

HANA optimized planning with BW-IP
Uwe Fischer
Business Card
Company: SAP AG
Posted on Nov. 28, 2011 03:34 AM in Enterprise Data Warehousing/Business Warehouse, In-Memory Business Data Management

URL: http://www.sdn.sap.com/irj/sdn/ip

In-memory technology is a success story within SAP NetWeaver BW for many years. The introduction of SAP NetWeaver BW accelerator provided a new level of reporting performance and became role model for others. Since then there was a strong desire to significantly accelerate planning use-cases with this technology, too. The value proposition can be summarized to:

Improved plan quality (allow more simulations cycles)
Improved user experience (provide better response time)
Improved plan accuracy (process higher data volume)

In general it is the mass data operations that benefit the most from in-memory technology: in reporting it naturally is the aggregation, in planning the disaggregation. But within planning there are much more mass data operations and every planning function is a candidate.

However for a significant performance benefit, mass data operations need to stay within the data layer completely, including data read, calculations and write-back. BWA did not provide the durability of an acid-compliant database and as such was a secondary store which could not manage written-back data. With SAP HANA the same technology becomes available now with full acid-compliance.

To understand what it means to have the complete operations in HANA, let us look at the processing on a classical database (the width of the arrows describe the volume of data transferred):

First the data is read into a local cache in the application tier. There it is exposed into the plan session which is used to feed both, the BEx query for the end-user and the calculations in planning functions or disaggregation in the query. The calculations are tightly bound to different other components: the metadata of the plan application, constraints like characteristic combinations that the calculations must not violate and the delta buffer that contains the pending changes. These buffered deltas together with the locally cached data feed again the plan session. Finally the deltas in the buffer are written back to the database upon a save-command. All this is handled in the application tier for classical databases.

With HANA optimized planning all steps, data read, calculations and write-back, are done in HANA completely. The components remain the same:

The plan session orchestrates the data flow between the physical data indexes and the consuming BEX query, the calculations in planning functions or disaggregation in the query. The data is read via projections into the level of aggregation demanded. The calculations are applied and the result written back into a delta buffer within HANA which is subject of further data requests. With this all mass data operations remain within HANA and only query relevant data and meta-data is exchanged between the application tier and HANA leading to significant reduction of IO-costs. In addition the columnar storage and parallel processing provide superior performance.

As a great benefit of this design the complete user experience remains untouched. This is true for the end-user clients (e.g. BEx suite, Advanced analysis for office) as well as for the modeling UI (ABAP planning modeler) and all existing BW-IP models. I.e. there is no need to migrate BW-IP scenarios to run on HANA. Adjustments might be considered though to optimize the HANA usage since not the complete BW-IP feature set can be executed in HANA today (see note 1637199). The other way around, all capabilities offered in HANA are available in the ABAP runtime as well. This allows to toggle between two operation modes of BW integrated planning on HANA:

Coming from an existing BW 7.x installation (A), the upgrade comprises a simple upgrade to BW 7.30 SP5 on the existing database and a subsequent database migration to HANA. Here BW-IP leverages the SQL-interface of HANA leading to superior read performance. Plan calculations are executed in ABAP (B), still. Their execution in HANA can be enabled by activation of the planning applications kit, activated by flipping a switch (see note 1637199) (C). The planning applications kit leverages the calculation and planning engines build into HANA to process the plan calculations in the best possible performance. This way the planning applications kit combines the feature-rich capabilities of BW-IP with the superior performance of SAP HANA.

Finally let me summarize the relation between BW-IP and the planning applications kit (PAK).

	BW-IP	Planning applications kit (PAK)
End user UI	identical
Modeling tools	identical
Feature set	identical
Full HANA optimized	no	partially ¹⁾
Further investment	no	Yes
License	no	yes ²⁾
	¹⁾ SAP Netweaver BW 7.30 SP5 ²⁾ License required for SAP BusinessObjects Planning and Consolidation, Version for SAP NetWeaver'

Uwe Fischer is development manager in the SAP BW analytic server.

Comment on this weblog

Showing messages 1 through 2 of 2.

Titles Only	Main Topics	Oldest First

License
2011-11-28 10:15:34 Ethan JEWETT Business Card [Reply]

This blog was really clear and helpful, but it ends with a bombshell. Am I reading this right? If you want to use the "in-memory" planning engine for BW IP you need to purchase a license for BPC version for Netweaver?
- License
  2011-11-28 11:59:38 Henrique Pinto Business Card [Reply]
  
  Yeah, the text is ambiguous. "License for BPC" can be interpreted as:
  
  1) you need to license BPC in order to use PAK;
  
  2) you need to license BPC if PAK is going to be used for BPC frontend.
  
  2) is highly unlikely, though, since BPC frontend is not mentioned anywhere in the blog, and the existing communication talk about BPC over HANA only on early 2013.
  
  Additionally, if you read the aforementioned note (https://service.sap.com/sap/support/notes/1637199), it states:
  
  "Use of the ABAP Planning Applications Kit requires a license for the following SAP functionality: 'SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver'."
  
  which could also be interpreted either as 1) or 2) above.
  
  As mentioned, I personally interpreted it as 1).
  
  BR,
  Henrique.

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27521%3Futm_source%3Dtwitterfeed%26utm_medium%3Dtwitter%26utm_campaign%3DFeed%253A+SAPNetworkWeblogs+%2528SAP+Network+Weblogs%2529

저작자표시 비영리 동일조건

'Technique > SAP HANA' 카테고리의 다른 글

HANA vs. Exalytics: an Analyst's View (0)	2012.05.08
SAP HANA SQL for bizy geeks: Episode #1: The importance of being TINY, Data Types and other beasts (0)	2012.05.06
Dealing with R and HANA (0)	2011.11.29
How to Best Leverage SAP BusinessObjects BI 4.0 on SAP HANA 1.0 - Webinar Presentation (0)	2011.11.29
Updates on the SAP HANA Roadmap and Overall In-Memory Strategy (0)	2011.11.25

Posted by AgnesKim

«이전 1 2 3 4 5 6 다음»

'sap'에 해당되는 글 59건

'Technique > SAP BW' 카테고리의 다른 글

'Technique > SAP BW' 카테고리의 다른 글

'Technique > 그외' 카테고리의 다른 글

Introduction

Exalytics

HANA: the Features that Matter

Exalytics: the Features that Matter

HANA vs. Exalytics

HANA: the Design Idea

So What Makes It Better?

Will HANA Have Legs?

About David Dobrin

'Technique > SAP HANA' 카테고리의 다른 글

'Technique > SAP BO' 카테고리의 다른 글

All You Need to Know about HybridProvider in BW 7.30

'Technique > SAP BW' 카테고리의 다른 글

Enterprise Performance Management How-to Guides

Disclosure Management

Spend Performance Management

Strategy Management

Profitability and Cost Management

Financial Consolidation

Business Planning and Consolidation, version for the Microsoft Platform

BPC 5.x

BPC 7.0 (MS)

BPC 7.5 (MS)

Business Planning and Consolidation, version for the SAP NetWeaver Platform

BPC 7.0 (NW)

BPC 7.5 (NW)

BPC 10 (NW)

Other Information and Articles

SAP Strategy Management

SSM 7.0

SAP BusinessObjects Planning and Consolidation

Blog Wiki *NEW*

Tools*NEW*

Reporting

Logic

Performance

Microsoft SQL 2005 Database Info Related

'Technique > SAP EPM' 카테고리의 다른 글

Using reCaptcha at SAP Portal 7.3 Logon Page Erhan Keseli Business Card Posted on Nov. 28, 2011 05:19 AM in Enterprise Portal (EP)

'Technique > 그외' 카테고리의 다른 글

Passing query parameters in background to a BEx report deployed in Enterprise portal Sriramvijay.R Business Card Company: L&T Infotech Posted on Nov. 27, 2011 06:49 AM in Enterprise Data Warehousing/Business Warehouse, Enterprise Portal (EP)

'Technique > SAP BW' 카테고리의 다른 글

HANA optimized planning with BW-IP Uwe Fischer Business Card Company: SAP AG Posted on Nov. 28, 2011 03:34 AM in Enterprise Data Warehousing/Business Warehouse, In-Memory Business Data Management

'Technique > SAP HANA' 카테고리의 다른 글

카테고리

공지사항

태그목록

최근에 올라온 글

최근에 달린 댓글

글 보관함

달력

링크

티스토리툴바

Blog Wiki NEW

ToolsNEW

Using reCaptcha at SAP Portal 7.3 Logon Page
Erhan Keseli
Business Card
Posted on Nov. 28, 2011 05:19 AM in Enterprise Portal (EP)

Passing query parameters in background to a BEx report deployed in Enterprise portal
Sriramvijay.R
Business Card
Company: L&T Infotech
Posted on Nov. 27, 2011 06:49 AM in Enterprise Data Warehousing/Business Warehouse, Enterprise Portal (EP)

HANA optimized planning with BW-IP
Uwe Fischer
Business Card
Company: SAP AG
Posted on Nov. 28, 2011 03:34 AM in Enterprise Data Warehousing/Business Warehouse, In-Memory Business Data Management