Dance card open:
-R
-BIRT/TRIRIGA
-PowerBI (soon)
Refreshed my github, fortran, sas chops...(for four-five month R project...:))
...and it's not happening...
two months ramp up/onboard at 10hr/week.
and then extending my project duration by same.
Dance card is open for: BIRT / Tririga, R language, MS-Access/Excel other)(Training myself in Tableau and PowerBI (I knew its predecessor "PowerPivot"add-in in Excel)
P.s. ...OR Fortran / SAS...:p
IBM Tririga OCA generated shells & SSO...
SSO in Tririga doesn't appear to like to start
from a report design you "roll yourself".
That is, I had 4 IBM Tririga OCA generated
queries - pasted Tables / datasets from them
into a _fresh_ report design - and though it
worked within Eclipse and Tririga non-SSO
accounts - SSO fails. SSO login _needs_
some magic buried in the XML depths of
these 'BIRT export' shells.
I discovered by accident in that the default
IBM Tririga OCA generated queries would
publish fine and run under SSO. So, I
copied formatted tables (and their datasets)
from the other three queries into the
"first one" of the set that I had working.
This was publishable/runnable under SSO.
#TRIRIGA #SSO #MULTIDATASETS
Working with BIRT (Business Information Reporting Tool) - Eclipse based.
It reads/writes out memory variables but inconsistently. If you do NOT have more than one report line it won't / doesn't seem to want to write them out from the report footer. Thinking if row_count=1 perhaps? I could write out the memory variable from the detail 'render' line?
Where is the BIRT object model to be found??
Google Chrome 64bit beta
Trying Google Chrome 64 bit - two-factor
authentication - didn't seem like it was
working.
...
Message windows would pop up - but,
couldn't be closed.
:(
My LG phone _interrupted_ me to install a security update...
My LG phone _interrupted_ me to install a security update...
...I actually liked that. It forced an update as soon as I
laid my phone down on my charging pad.
...I actually liked that. It forced an update as soon as I
laid my phone down on my charging pad.
PowerApps manages contention for resources...
Interesting - in my PowerApps app - it queues changes and populates using a "__PowerAppsId__" column...if spreadsheet locked it posts once free!
*GREAT* page:
http://bit.ly/22Pubt0
aka
https://www.ntu.edu.sg/home/ehchua/programming/sql/MySQL_Beginner.html
aka
'MySQL Tutorial - MySQL by Examples for Beginners'
RedNotebook vs. Evernote
I'm divided as to whether to use RedNoteBook or Evernote for keeping my work journal. RedNoteBook is nice in that it is opensource and simple. Integrates with dropbox.
Evernote is slick because it's ubiquitous and feature rich.
...
Choose RedNote
Adventure of the mailmerged numbers - or, when data bleeds so does the programmer
In process of upgrading company computers we had to rewrite a data source for a mail merge being done in MS-Word and MS-Access. Once the data source had been changed from a MS-Access database to MS-Excel all seemed well --accept for the numeric fields. The "smart" default for Excel takes longish numbers and automatically transposes them to scientific notation. Dollar amounts as they appeared in the MS-Word automatically went from 2 digit precision to a floating point number(actually, it looked as if it turned it into an irrational). Any subsequent tweak to the data to get it to _look_ like text appeared doomed. Tried pre-pending an apostrophe, tried suffixing a space, etc. Some of these were successful, but, it meant showing the extraneous character on final output. Granted a pre-pended '#' on long numeric data and '$' on monetary may have been acceptable -- it just should _not_ have to be. Ultimately, layering the numeric data in '=text(' || field || ',"0")' and '=text(' || fieldb || ',"0.00")' worked. This adventure coupled with mail merge seeming to never remember the path to it's data source has led me to believe I killed one two many trees back in the days when I was a COBOL programmer. The IT universe seeks revenge. Or, perhaps it is just wants to slow us down. Every hour debugging is another hour not producing letters.
On my way out the door my co-worker tried to cheer me with the news that the next department to get new computers also require mail merge conversions.
On my way out the door my co-worker tried to cheer me with the news that the next department to get new computers also require mail merge conversions.
My Oracle @desc.sql
Here's procedure source...
xx9999@oi>@list.sql desc.sql
desc.sql
set echo off
set linesize 80
set newpage none
spool &1..1.txt
describe &1
spool off
set echo on
!sort &1..1.txt -o &1..2.txt
!grep -v " -" &1..2.txt>&1..3.txt
!grep -v "l?" &1..3.txt>&1..4.txt
!cp &..1.4.txt &1..txt
!rm &..1.1.txt
!rm &..1.2.txt
!rm &..1.3.txt
!rm &..1.4.txt
!vim +2 &..1.txt
Here's example use...
@desc all_tables AVG_ROW_LEN NUMBER AVG_SPACE NUMBER AVG_SPACE_FREELIST_BLOCKS NUMBER BACKED_UP VARCHAR2(1) BLOCKS NUMBER BUFFER_POOL VARCHAR2(7) CACHE VARCHAR2(5) CHAIN_CNT NUMBER CLUSTER_NAME VARCHAR2(30) DEGREE VARCHAR2(10) EMPTY_BLOCKS NUMBER FREELISTS NUMBER FREELIST_GROUPS NUMBER INITIAL_EXTENT NUMBER INI_TRANS NUMBER INSTANCES VARCHAR2(10) IOT_NAME VARCHAR2(30) IOT_TYPE VARCHAR2(12) LAST_ANALYZED DATE LOGGING VARCHAR2(3) MAX_EXTENTS NUMBER MAX_TRANS NUMBER MIN_EXTENTS NUMBER NESTED VARCHAR2(3) NEXT_EXTENT NUMBER NUM_FREELIST_BLOCKS NUMBER NUM_ROWS NUMBER OWNER NOT NULL VARCHAR2(30) PARTITIONED VARCHAR2(3) PCT_FREE NUMBER PCT_INCREASE NUMBER PCT_USED NUMBER SAMPLE_SIZE NUMBER TABLESPACE_NAME VARCHAR2(30) TABLE_LOCK VARCHAR2(8) TABLE_NAME NOT NULL VARCHAR2(30) TEMPORARY VARCHAR2(1) "all_tables.txt" 38L, 1900C
Support procedures ~ menu
I created a support menu for myself for frequent access items. Using Korn shell with no extentions -- but,
with the first line ='#!/usr/gbin/ksh' (to inform OS I'm using ksh).
::/mnt/replicated/apps/datamodules/_SUP> cat menu
#!/usr/bin/ksh
# - -----------------
# description: menu ~ displays list of commands
# -
. ../_CMD/db_setup_DSS.ksh 2>&1 >/dev/null
. ../_CMD/set_mmdd_DSS.ksh 0 2>&1 >/dev/null
grep -h "description" *|grep "#"|grep -v "grep"
::/mnt/replicated/apps/datamodules/_SUP> menu
# description: consolidated ~ starts mysql with the consolidated database
# description: dailysettlements ~ starts mysql with the dailysettlements database
# description: dss ~ starts sqlplus with the dss oracle instance
# description: edb ~ start sqlplus with the edb oracle instance
# description: menu ~ displays list of commands
::/mnt/replicated/apps/datamodules/_SUP>
SimpleMind ~ diagram tool for Android and desktop
http://bit.ly/SimpleMind_MTBee
Method PP to SSAS Tabular
Many sheets using GETPIVOT data will copy directly via copy/paste. Trick is to rename the 'PowerPivot data' to yourmodel connection in the pp source model to beforehand. Pivots may have to be reconstructed.
Subscribe to:
Posts (Atom)