With UD Connect you can now integrate the data for the source object into SAP BW. You can either extract the data, load it into SAP BW and physically store it there, or, as long as the prerequisites for this are fulfilled, you can read the data directly in the source using a SAP RemoteCube…. Continue reading
First, if there is an error on the activation of a DataSource Object (DSO) or the Transfer Rule Object. Run this transaction code: RSRV: Analysis and Repair of BW Objects Second, If an SAP BW InfoObject get an enhancement then it should be repaired too. Apply these steps: Run this transaction code: RSA1 : Goto… Continue reading
SAP BW Client – SBIW : SAP Business Information Warehouse IMG (Implementation Guide) – RSA1 : Modelling DW Workbench. This is Main Transaction – SCC4 : Client Administration (BASIS Area) – RSECADMIN : Authorization, Replacing Obselete RSSM – SE10 : Transport Organizer – RSPC : Process Chain Maintenance – SE37 : ABAP Function Modules –… Continue reading
SAP ERP is the flagship ERP solution from the third largest software company in the world. So it has to be good, right? That’s the marketing hype, but does that mean that SAP ERP is good for the particular needs of your organization? Because at the end of the day, that’s what really matters. And… Continue reading
In many Business Intelligence implementation cases, there’s a certain difficulty for IT Pro to explain or describe the difference between OLTP (OnLine Transactional Process) and OLAP (OnLine Analytical Process). I hope the table below might help a little. source: 360decisions
IIf function often used in MultiDimensionalExpression (MDX), It’s quiet simple to implement single block of IIf block. This an example of Multiple IIf logic block. Example1:
|
1 2 3 4 |
IIf(Measures.[Store Sales] > 50000, "Good", IIf(Measures.[Store Sales] > 30000, "Average", IIf(Measures.[Store Sales] > 10000, "Poor", "No"))) |
A logical script in MDX to perform an “If..Then.. Else..” block.
|
1 |
IIf(«Logical Expression», «Numeric/String Expression1», «Numeric/String Expression2») |
Example1:The following example returns 0 if Measures.CurrentMember is an empty cell, 1 otherwise:
|
1 |
IIf(IsEmpty(Measures.CurrentMember), 0, 1) |
Example2:The following string returns the string “Yes” if Measures.CurrentMember is an empty cell, the string, “No” otherwise:
|
1 |
IIf(IsEmpty(Measures.CurrentMember), "Yes", "No") |
Example3:
|
1 2 3 4 5 |
IIf( [Scenario].CurrentMember IS [Scenario].[Budget], [Measures].[Budget Unit Sold], [Measures].[ActualUnit Sold] ) |
Example4:Average Sales (Measure) By Time Day (Dimension)
|
1 2 3 4 5 6 7 |
IIf ( ([Time].currentmember.level.name = "(All)" OR [Time].currentmember.level.name = "Year" OR [Time].currentmember.level.name = "Quarter" OR [Time].currentmember.level.name = "Month" OR [Time].currentmember.level.name = "Day" ),AVG(Descendants(Time.CurrentMember,[Time].[Day]),Measures.[Sales]),0) |
Source:… Continue reading
There’s a few scenario to calculate a percentage of a measure in OLAP CUBE (Analysis Service 2000). A Percentage is common calculation in MDX , and it can be solved by divide a measure to total value (Grand Total). Sample 1:Measures.[Value Contribution to Total]:
|
1 |
(Measures.[Value] / (Measures.[Value], Time.[All Time], Products.[All Products],…) |
Sample 2:Measures.[Value Contribution to Total]:
|
1 |
(Measures.[Value] / (Measures.[Value], Products.[All Products],Warehouses.[All Warehouses]) |
Sample 3:Measures.[Product Contribution to… Continue reading
This post is copy from http://gumper.com, a unique website coz it’s only have one item…. The basic script of Multi Dimensional Expression (MDX). It’s very usefull for developer to build some scenarios in a CUBE. thank you, hope it’s ok i copied all the page. MDX Expressions Function Requires Returns CurrentMember Dimension Member PrevMember Member… Continue reading