Hack

Configuring private V2Ray server for bypassing internet censorship (TLS configuration)

Today many countries are trying to block access to internet resourses that are not convenient for them – oppositional websites, social resourses and so on. In this article you will find solution that will works at most of such circumstances

Bash script to automate generation of certificates in WireGuard VPN

In this post you will find two easy bash scripts that can help you in process of generation multiple certificates in WireGuard VPN service. I create it to reduce time of certificate generation for myself, but it can be useful for you, as I could not find such solution with

Hack

Best MacOS apps for advanced users (personal recomendations)

In this post I would like to share all my favourite apps for Mac OS, which I use in my life and which I would like to recommend to Mac users. Productivity Notion (freemium model) – app that allows to keep notes, run projects, create knowledge databases in one place and

Hack

Convert PDF to PDF with only images to prevent it from editing

This article with describe how to convert PDF file to PDF consisting only from images. This operation permits future editing PDF using such converters as iLovePDF. To do this you need to install imagemagick from there official site, or install via package managers. For Mac OS you can use brew

Hack

Compress PDF files using GhostScript

This post describes method how to automate process of compressing PDF files in Mac or Linux environments using GhostScript library. First of all you need to install GhostScript library on your computer. On mac os you can do it with brew: brew install ghostscript Or using apt on Linux systems

NodeJS

Convert XLSX file with multi level header to plain CSV and JSON

Convert XLSX file with multi level header to plain CSV or JSON file with all headers information.

Hack

Light Node.js script to send large files P2P

In this article you will find two lightweight Node.js scripts that will allow you to send very large files from one computer to another peer-to-peer (P2P). There is a lot of different scenarious when they can be usefull: for example if your file is too big to be send

Cognos

Definition of system lines in Cognos TM1 Views files (.vue)

In this article I will disclose information about how Cognos TM1 stores information about cubes views in .vue files. For Cognos TM1 developers this information can be usefull in many different situations, for example: 1. For automatic updates of views – changing used subsets, chosen elements of context dimensions; 2. Finding

Cognos

Definition of system lines in Cognos TM1 Subset files (.sub)

In this article I will disclose information about how Cognos TM1 stores information about dimensions subsets in .sub files. This information can be usefull if you are Cognos TM1 developer and need to automatically change many subsets in some way, for example: turn on/off expand above in multiple subsets,

Cognos

Installation and using of Cognos BigFix and ILMT – tips, bugs and features

In these article I would like to disclose some extra information about installation and work of Cognos BigFix and ILMT systems. Problem with obtaining evaluation license key While installing of BigFix Server you can encounter some problem with obtaining the key from IBM with error related to timeout: "Unable to

Cognos

Change server address in Cognos Analysis for Microsoft Excel (Cafe) files (manually and using NodeJS)

Case: You have a lot of excels created with Cafe tool. But at once you move your servers to another address or may be there is a need to create copy of excel to connect to dev/test server. Cognos TM1 does not give us easy way to do this

Hack

Compare folders states with Nodejs

Case: You have large folder and some process that makes changes in it. As there are too many nested folders and files there, manual comparison can take too much time, so you would like to find quicker and easier way. In this post I would like to share with you

Cognos

Return custom error message from attached process in Cognos TM1 Application

Instruction how to return custom error message to Cognos TM1 Application user from attached process

Cognos

Error in TM1 Applications: "View is corrupted or user doesn't have read permissions"

User could not access view in Cognos TM1 Applications after recreating of the cube.

Cognos

IBM Cognos TM1 code completion for Sublime Text editor

If you tied from absence of code completion for Cognos TM1, I have good news for you. Today I publish TM1SublimeCompletion package for Sublime 3 that can solve this problem. Description Package contains completions for all TI, Rules, Worksheet and MDX function, global and local variables of IBM Cognos TM1

Cognos

Definition of system lines in Cognos TM1 Process files

In this article you will find definitions of the common codes, that are used in Cognos TM1 .pro files. I still work on it, so it will be updated later. There are 2 more simular articles about Cognos TM1 system codes in files: 1. Definition of system lines in Cognos

Cognos

Change Cognos TM1 Applications default load order

After updating of Cognos Applications, Cognos reorders them by date of update. But you need to show them ordered by name. This is instruction how to do that

Cognos

Colorize Cognos TM1 Application Portal

If you have 3 Cognos TM1 servers: 1 production, 1 test and 1 development and you would like to make work with them more user-friendly to avoid mistakes of working in wrong environment, then this article is for you

Cognos

Cognos Cafe Error "InvalidMDXExpression ... (rte 390)"

When user tries to update data in excel connected to Cognos TM1 with Cognos Cafe, system returns error – "InvalidMDXExpression: SELECT: ... (rte 390)".

Cognos

Best practices and tips writing Cognos TM1 TI Processes and Rules

In this article I would like to write some tips that can be usefull for TM1 developers. Some of them will be very common and easy, but still some will be very usefull and important. Write code in appropriate place My first recomendation is to develop in special dedicated text

Hack

Port forwarding – script to transform your PC into proxy

In some situations companies security services can forbid access to important server from WAN network, but still allow connections to your computer that has full LAN access (usually throw VPN-service). In this situation, most common sollution to access server is to connect to your personal computer using RDP and then

Windows

Check lock and unlock Windows files using Powershell script

Here is the PowerShell script to force close programs that lock some Windows file. This can be usefull in many situations, for me it was necessary before updating IBM Cognos PowerPlay cubes. As some programs (for example IBM PowerPlay) can lock it, and do not allow any modifications: delete, copy

Hack

Automate connection to Cisco AnyConnect VPN on Mac OS using terminal and expect

Bash script to automate Cisco AnyConnect connection to VPN network

Cognos

Cognos TM1 + Control version using Git

In this post you will find information how to control versions of your Cognos Tm1 system using GIT. Why this can be usefull for you? Here are some reasons for that: * You need to trace changes that was made to the rules and processes throw the time. Especially it be

Cognos

How manually add cell comments from TM1, using }CellAnnotations cube

Instruction how manually add comments to cells in Cognos Application from TM1, using }CellAnnotations cube