find better solutions for analytics world
I tried following approach and it worked.
rename .twb file to .xml
(if your tableau file is twbx then rename this file to .zip . get .twb file from this zip file. )
Open in notepad
search for following text:
change ’16’ to your desired value.
Now rename the .xml back to .twb. Open in tableau.
Though you could add more columns in tableau by changing xml, UI doesn’t look good. As tableau doesn’t support scroll bar on “Rows”
When skype is added as an add-in then opening outlook calendar invite takes longer time to open. Disabling skype at outlook would resolve this.
At outlook go to file –> options –> Add-ins –> Manage – COM Add-ins GO –> At add-ins available uncheck skype related items.
Tableau tabcmd error
tabcmd login -s https://tableauserver.com -t site1 -u username –p password
*** Uncaught exception RuntimeException: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path building failed: sun.securi
ty.provider.certpath.SunCertPathBuilderException: unable to find valid certifica
tion path to requested target
When you get this error there are 2 ways of solving:
Solution1: Add tableau weburl to your trusted url’s in IE.
Solution2:
add –no-certcheck
tabcmd login -s https://tableauserver.com -t site1 -u username –p password –no-certcheck
and append –no-certcheck to export commands as well.
https://en.wikipedia.org/wiki/Regular_expression
Python Regular Expression Quick Guide:
when trying to join a table with lat, long values with Shape file follow below steps .
Add below to the query item.
geography::STPointFromText(‘POINT(‘ + CAST([LONG] AS VARCHAR(20)) + ‘ ‘ + CAST([LAT] AS VARCHAR(20)) + ‘)’, 4326) as loca_geo
join should be Intersects
Join to geometry.
percentage([Counts])
percentage(count (distinct [DataItem]))
Create a calculation by above syntax. Drag that column to cross-tab. You should be getting percentages of summary data.
Topics: Cognos Cross Tab & percent calculation in Total
cognos cross tab how to add percentage
https://it.toolbox.com/question/crosstab-percent-calculation-in-total-071706
in progress…
cognos notification test pass but email doesn’t come
Unable to send emails from Cognos Server but no errors appear in the cogserver.log file
https://www-01.ibm.com/support/docview.wss?uid=swg21339824
https://www.cognoise.com/index.php?topic=26364.0
https://it.toolbox.com/question/cnc-sds-0408-there-are-email-messages-waiting-to-be-sent-072011
CNC-SDS-0408 There are email messages waiting to be sent.
CNC-SDS-0410 The email message was not sent
https://www-01.ibm.com/support/docview.wss?uid=swg22012214
cognos analytics [Validate mail server properties.] [ ERROR ] The mail server cannot be reached.
Cognos Scheduled Jobs Randomly Stuck in ‘Waiting’ State
https://www-01.ibm.com/support/docview.wss?uid=swg21689979
Testing mail server connection: [ERROR] Mail server authentication failed
https://www-01.ibm.com/support/docview.wss?uid=swg21342280
Data Engineering and BI BLOG 