tag:blogger.com,1999:blog-169622062024-03-13T17:16:55.545+01:00so many trails ... so little timepablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.comBlogger122125tag:blogger.com,1999:blog-16962206.post-19297155133745538912020-01-19T17:21:00.001+01:002020-01-22T10:55:08.120+01:00Simple Brompton hackInspired by a post on Facebook group "Brompton Hacks" I decided to do the same, this is a short note about what I did, actually changing your rear wheels to something useful both when pulling the bike and when letting the bike stand folded.
I can't understand how and why Brompton doesn't provide something like this as a default, so here it is, a simple upgrade/hack that should be standard pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-51094320331048223512014-12-05T17:28:00.000+01:002014-12-08T10:44:32.674+01:00One of the most useful SAP Notes for BWGreat note for those tuning BW parameters
912367 - Composite Note: RSADMIN Parameter
pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-67161960360253612052014-04-24T12:16:00.000+02:002014-04-24T12:16:51.236+02:00Two very important SAP Notes for BW AuthorizationsThese two notes can solve a lot of problems, or at least give a good start ...
150315 - BW-Authorizations for Remote-User in BW and OLTP
161292 - Authorization templates for user roles and tasks
pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com1tag:blogger.com,1999:blog-16962206.post-58741722230229317982014-04-14T17:13:00.001+02:002014-04-14T17:14:31.303+02:00BPC filter 0CALMONTH in data packageA picture is worth a thousand words ...
so that's the correct format for 0calmonth.
pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-367042096251957172013-10-25T12:48:00.004+02:002013-11-12T10:35:17.168+01:00BPC Member formula ... devil is in the detailsI've found a "non working" item in BPC ... it's member formula was something like
<!--[if gte mso 9]>
Normal
0
14
false
false
false
IT
X-NONE
X-NONE
MicrosoftInternetExplorer4
<![endif]-->
<!--[if gte mso 9]>
pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-89390547379156867302013-08-18T01:23:00.003+02:002013-08-18T01:23:57.410+02:00pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-15009574642030989392013-04-02T17:02:00.003+02:002013-04-02T17:06:59.905+02:00BPC work status setup ... APPROVALORG, a little parameter often overlookedWhen setting up workstatus in BPC there is a little web parameter to setup, APPROVALORG, it's often overlooked because generally one doesn't manage more than one hierarchy for an entity ... in our case we have 3 hierarchies and hierarchy number 3 (H3) is the one used to manage read/write permissions and thus the natural candidate for controlling workstatus.
So the web parameter APPROVALORG shouldpablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-43329414455016208832013-01-29T18:33:00.001+01:002013-01-29T18:33:14.116+01:00BPC load 0CALMONTH from BWAs incredible as it sounds ... in BPC 7.5 NW you have to prepare a conversion to load time from 0CALMONTH to TIME dimension!
Thanks God it's not that difficult, once you know how to do it.
An example:
Time conversion file
pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-17510331328046167302013-01-28T14:55:00.001+01:002013-01-28T14:55:12.692+01:00BPC lite optimize zero eliminationJust a quick visual to add zero elimination to the light optimize package in BPC 7.5 NW, see SAP Note 1396761
Organize package list
Modify package Lite Optimize
Modify package Lite Optimize
Add task
pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com1tag:blogger.com,1999:blog-16962206.post-20714240655256374012012-07-03T17:15:00.002+02:002012-07-03T17:16:01.622+02:00BW dataflow examples for HR masterdataIt happens quite often, source data comes from a single infotype, but users want informations coming from different subtypes moved to different infoobjects on the same row (i.e. one row per employee per time period), this usually requires some ABAP but there is a trick.
You can use infosets to differentiate logically between rows of the infotype, see below:
This example is quite specific for pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-18651649333765057572012-04-06T15:27:00.002+02:002012-04-06T15:27:09.509+02:00Texts in the output of an APDThere seems to be interest in outputting not only the query results in APD but also some texts, which is currently not supported by simply having the query output contain texts as anyone would expect.
But, there is an easy solution, see figure below
Here you are.
Sending it out to a file doesn't change the other steps.pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-7460503289487584062011-10-27T12:07:00.002+02:002011-12-11T10:49:40.521+01:00Calculations with key dateA bit of follow up to the previous post ... we'd like to have the key date at hand for performing some calculations, unfortunately we didn't find an easy way so with some micro abap we managed to get that variable into another variable (??) that can be used.
Coding for variables (CMOD on BW side, EXIT_SAPLRRS0_001, include ZXRSRU01 etc.) follows:
Wish there was a simpler way ...
Code:
case pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-29573663632729622952011-08-22T17:17:00.016+02:002011-11-09T14:12:30.557+01:00Prompts in SAP BO OLAP universe (query key date)
Having recently struggled with a key date prompt in a BO universe built on a BEx query ... I'm posting here some samples and screenshots of the outcome as I didn't find/couldn't understand documentation on this ....
The universe wizard in my case didn't generate something usable out of the box, so I had to tweak it a bit
First one, how to show it as a datepicker (sounds strange ...)
Thepablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com3tag:blogger.com,1999:blog-16962206.post-35895760918204485612011-07-20T12:43:00.007+02:002011-07-30T22:30:37.335+02:00Filtering on hierarchy values in DTPHaving spent some time unsuccessfully googleing for a way to use a hierarchy as filter in a DTP I've come up with a (rather inelegant) solution myself.Posting it here in hope it's helpful. Code: DATA: l_idx like sy-tabix.DATA: lw_hier_id TYPE rshi_s_rshiedirkey.DATA: lt_nodes_a_leaves TYPE rshi_t_hienode.DATA: lw_nodes_a_leaves LIKE LINE OF lt_nodes_a_leaves.DATA: l_hier_name TYPE pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-43332194977612874832010-03-20T22:02:00.011+01:002010-06-01T22:45:02.937+02:00I love windows functions... or whatever they call those functions that allow ranking and anyway working on "windows" of data (or sets inside sets or ...).A couple of questions on Devshed forums I recently answered using those functions.First one is about recordset paging (well, there are hundred of ways to do recordset paging, just google, but ayway) LIMIT being one of them, stored procedures another one (and ugly IMHO)pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-10047177516367559332010-01-16T17:07:00.010+01:002010-01-16T17:59:26.568+01:00The missing link ...... between me and Firebird.The Tracker, that's it, claims are it's up again but it doesn't work for me.I'd love to open a feature request, or add my vote to an existing one, "role assignment to stored procedures".Actually I'm after assignment of the rdb$admin role to a stored procedure, in order to give unprivileged users the ability to perform some administrative tasks without the need for pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-33211464505217855502009-05-23T10:18:00.012+02:002009-05-23T10:42:38.229+02:00Consuming webservices in JSP with Apache AXISThis is a rather old tutorial moved here from my old site on Geocities, hope it's still useful.Recently I started fumbling around with webservices, a nice integration and communication tool for my customers, what follows is a work in progress, which is going to be enhanced while I proceed in my “trial and error for the illiterate” learning path.First of all I installed AXIS (http://ws.apache.org/pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com1tag:blogger.com,1999:blog-16962206.post-59728752055676722362008-11-02T11:27:00.016+01:002008-12-26T14:20:25.637+01:00Old challenges, new synthax ...I've blogged before about the new SQL synthax which is becoming available in databases and how it helps solving questions which are increasingly common.Now it's time for another example, something which doesn't come up often in a reporting environment as most tools have this feature, but can be a problem if you're building your output with a scipting language.Adding a "Total" row at the end of pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-66727662197712713712008-10-01T12:01:00.004+02:002008-10-01T12:40:00.226+02:00Adding an OpenLDAP server as SQLServer linked server... and querying it.You can link to an OpenLDAP server from SQLServer by:1. Running the following stored procedures:Use mastergoexec sp_addlinkedserver'ADSI_OpenLDAP', --name of the linked server'My OpenLDAP Linked server', --description'ADSDSOObject','adsdatasource'goexec sp_addlinkedserverlogin'ADSIOpenLDAP',False,'sa','your_root_dn','your_root_dn_password'goNote that this skips each and every pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-78406245228253210212008-09-08T19:04:00.017+02:002009-04-03T23:57:57.259+02:00Random selection, with a bias ...Say you want to randomly select your employee of the month, but not so randomly, better, you'd like to give your best employees a bigger chance to be selected based on their rating.This is just an example, you could be randomly displaying ads from your customers, but giving an higher chance to be displayed to those who are paying more, there can be a million other example, but I hope you got the pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com0tag:blogger.com,1999:blog-16962206.post-25682136776296764572008-07-29T15:00:00.026+02:002008-07-29T16:14:08.034+02:00Setting up ColdFusion and FirebirdAfter a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don't see why it and ColdFusion can't play nice together ... infact they did, and easily.Already having installed on my PC the database (Firebird 2.5 Alpha1) and a client tool (Flamerobin 0.8.6) I went for the server, downloading and installing the free developer version of ColdFusion 8 from Adobe's pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com4tag:blogger.com,1999:blog-16962206.post-15745889456640047232008-07-27T12:19:00.017+02:002008-07-29T14:59:47.395+02:00The new MINI ClubmanI'm the happy owner of a New MINI ONE and had a chance to try the New MINI Cooper Clubman, which, apart being the bigger sister of my car, is also a second generation New Mini, which means new engine, new steering and some other things ... unfortunately not all of them are nice.First of all, the new engine seems to be better than the old one, with a nice sound and good power.The new steering is pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com1tag:blogger.com,1999:blog-16962206.post-27104169268504665542008-07-22T15:52:00.016+02:002008-08-15T09:52:58.896+02:00PostgreSQL - Firebird comparisonGoogle led me to a comparison sheet about PostgreSQL and Firebird by AMSoftwareDesign, as it looks a bit outdated I decided to add some infos about the latest Firebird release, see it in action: PostgreSQL vs Firebird feature comparison Feature PostgreSQL 8.2.x Firebird 2.0.x Firebird 2.5 Alpha MVCC Yes Yes Yes Row level LockingAvailable Yespablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com4tag:blogger.com,1999:blog-16962206.post-80103988349751000912008-07-22T12:47:00.006+02:002008-07-22T12:58:46.667+02:00Has them allA question that pops up frequently on Devshed forums is "How can I get all products that are available in Red and Green colors?" or "How can I find out which customers bought this book and that CD?", solution is simple and I'll provide an example here, it can be made more complicate at your option, but it all boils down to a where and an having condition.Say we have a table that lists all pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com2tag:blogger.com,1999:blog-16962206.post-55405562003791515482008-07-21T15:19:00.008+02:002008-07-25T10:48:11.576+02:00Another great new feature of Firebird 2.5Other than CREATE USER something really valuable has been added, the ability to query other databases.Using a table structure like my previous post what follows is an example of a query running on an external database:SET TERM ^ ;CREATE PROCEDURE GET_MASTER_PROD_ALL_EXTRETURNS (P_CODE Char(5),I_ENABLED Char(1),P_DESCR Varchar(50) )ASdeclare variable qry varchar(5000); BEGINqry = 'SELECT pablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.com4