Inventory board (OLAP cubes)
Implemented using MS-OLAP cubes. Underlying database is MS-SQLserver, populated from mainframe databases via DTS/stored procedures. • The board depicted is part of a suite comprising the Purchasing and Inventory functions for the corporate high and middle management. • Visibility scope is restricted according to user’s administrative level. • I've done the database design and programming. The UI belongs to a commercial platform for cubes handling.
Mi perfil
"If human thinking fails, try anthropoid thinking. Fresh approach helps remove the obstacle." There used to be an ape-man in the photo: MoonWatcher. His bio takes us way back in time. I like to think of MoonWatcher as my oldest known ancestor. Had he lived in our times, he'd be well versed in the following: ● Database systems: • Airtable: database design, automation and scripting. • MS-Access, his sentimental favorite, which handiness and versatility reminds of the ancient bone-made tools. • other databases: MS-SQLserver • MySQL • PL/SQL • DB2 SQL/400. • lastly a set of forgotten, prehistoric tools: dBase, Borland, Paradox, FoxPro. ● Programming languages (in alphabetical order): • ABAP (SAP) • C# • Cobol, all its reincarnations • IBM AS/400-iSeries, its languages: RPG, Cobol, CL, SQL/400, Query/400. • Javascript • Visual Basic, all its reincarnations As you've read up to this point, you may feel intrigued by MoonWatcher's origins and developments. Read the first chapters in Arthur Clarke's "2001, A Space Odyssey". There, the anthropoid's fears and amazements, his early attempts at understanding the world, are magistrally depicted.