Pivot: how to refresh pivot table on Excel file connected to offline cube

1. switch to Online
2. Refresh [data]
3. switch back to Offline (no need to re-run wizard)
4. check by clicking one of the dimension (list/values should appear without problem)

Messenger app related

Looking for a bot that redirects messages from whatsapp chats to a telegram chat (2019)
Question :
I have a few friends that do not use whatsapp and some that don't use facebook. Is there a way to somehow make a bot post all messages written in a whatsapp chat to a telegram chat and post the replies bavk to whatsapp?

(Telegram) How do I download big files in faster way from Telegram messenger?
Tested on August 9, 2019 (sometimes works, sometimes not): GetPublicLinkBot

Whatsapp: How do I find out number of groups in my WhatsApp?

WA: if I remove a contact, will our chat history remain visible on his/her phone ?
The text messages which you sent to your friend ,will be saved automatically to your friend’s history , there won’t be any chance for erasing itself when you delete his/her contacts ,until your friend desired to delete that message manually.
So, when you delete someone‘s contact from your contact list ,still they can see your text message history,until they delete that manually. (source)

Whatsapp@android: send directly to a number without save
WhatsDirect

Whatsapp: How to Use One WhatsApp Account On Two Phones At The Same Time
you can use your account on WhatsApp Web only once at a time

Whatsapp: How can I delete a group chat?
The only way that you can delete a group in WhatsApp is if you are the admin of the group and remove each participant from the group. After removing all participants, you will need to exit the group in order to see the delete group option

Whatsapp: Where is the contact list
The updated WhatsApp no more shows the contact tab where you could find all your contacts. Instead, it now shows message logo at the bottom which if you touch takes you to the 'select contact' page where you find all your all contacts (source)

Line: HOW TO CHECK YOUR FRIEND’S LINE ID
You cannot check someone’s LINE ID.
The only way to know someone’s LINE ID is to ask the person.

Can't change app permission on Samsung J7 Marshmallow

Error "screen overlay detected"
Solution: change permission setting on safe mode

Hunt for high pressured car washer

Pompa Penguat Semprotan Air High Pressure Car Washing Booster Machine
+ cheap (IDR 96.000)
- no installation manual in English/Bahasa

Jet Cleaner High pressure Washer Mesin cuci Mobil Motor
* IDR 750.000

Server 2003 administrative tasks related

Why does enable audit on SINGLE user FOLDER generate SO many log entries including ones that related to system files ?

Windows 2003 server file access audit
That is normal, unfortuante but normal.  When a machine opens a file there may be several hooks into the file to handle different things.  Each one of these is recorded in the audit log.

Only on Server 2008 or later
----------------------------------
File Auditing Server 2008 R2
I think the issue could be that he is using the basic "Local Policies \ Audit Policy -> Audit Object Access" settings. If you, instead, configure the "Advanced Audit Policy Configuration \ System Audit Policies \ Object Access -> Audit Files System OR Audit File Share" you might have better luck. I had the same issue and then I realized that the later is the better option and it seems to work. Don't configure both, just the "Advanced Audit Policy Configuration"
---

Server 2003 troubleshooting

Cannot change domain password from Remote Desktop session on NON DC server :
The users password must be changed before logging on the first time
See Best Answer (KB2927811)
---

Plenty of Event ID 675 with Failure Code 0x19 :

There are various causes to this error - which is a Kerberos error. One of the most common is the fact that Windows 2003 DCs inc SBS 2003 use a lower encryption standard than Vista/Win2k8/Win7. This generate a 0x19 error & possibly others. 0x18 errors seem to be to do with password failures

source

Event ID 11 "There are multiple accounts with name MSSQLSvc/..."

Terkait surat kendaraan

Kenalan Dengan Prosedur Tilang Yang Baru Yuk Gan!

analisa-ringan-penerapan-e-tilang-mulai-1-januari-2017-di-15-kota-besar-masih-saja-ribet
Jika putusan pengadilan menyebutkan bahwa denda tidak sebesar denda maksimal yang sudah di bayarkan (ditransfer) sebelumnya, maka uang akan dikembalikan ke pelanggar tentunya setelah dipotong besaran denda yang sudah ditentukan di pengadilan
Pelanggar harus melakukan kontrol yang ketat terhadap petugas, yaitu dari satuan mana, nama lengkap dan pangkat harus dicatat untuk memudahkan pelanggar mengambil surat yang disita dari petugas. Nah ini sama saja membuat ribet pelanggar

Dua Pekan Diberlakukan, Banyak masyarakat Belum Paham E-Tilang
Pengambilan SIM dan STNK nantinya tidak lagi ke Satlantas, tetapi ke PN atau Kejari.

Related
---------
SIM Corner di PTC - 3 Sep 2018

Cara Membayar Pajak Kendaraan Bermotor Online (Jatim)
Setelahnya tetap harus ke samsat :
Jangan lupa untuk menyimpan bukti pembayaran / transfer bank yang diterima karena nanti akan diminta pada saat mengambil nota pembayaran dan pengesahan STNK di Samsat. Bawa juga STNK lama dan KTP asli sebagai bukti. Tidak ada salahnya juga membawa BPKB, untuk berjaga-jaga apabila diminta oleh petugas.

Perpanjang SIM Anda Dengan Tanpa Antri Kelamaan, Melalui Jalur SIM Online
18 Sep 2018: Error validate SIM

Pengalaman Perpanjangan SIM di Surabaya 4-Feb-2018