Creating a list of Elasticubes and Replace Padding Letters In EC Names With Clear Characters
The names of the ECs are often accompanied by mysterious letters that make them hard to read. If you have a need to create a list of ECs with their clear names and the dates when they were last queried, you may follow the following steps: Create a text file which contains the names of the elasticubes: C:\ProgramData\Sisense\PrismServer\ElastiCubeData>dir > C:\Users\admin\Downloads\ECs.txt Clean the EC names by using the following Find and Replace strings 1. Remove timestamp with regex 2. Replace characters according to the below table Example: Before... 08/02/2020 22:50 <DIR> aADVATIXXwAaADILKAPOORXwAaECXwAav3 15/06/2020 15:39 <DIR> aAdvIAAaCertificationIAAaLQAaIAAaUseIAAaCaseIAAaLQAaIAAaDataIAAaSecurity 15/06/2020 15:39 <DIR> aAdvIAAaCertificationIAAaLQAaIAAaUseIAAaCaseIAAaLQAaIAAaDataIAAaSecurity_Alternative 15/06/2020 09:22 <DIR> aAdvIAAaCertificationIAAaLQAaIAAaUseIAAaCaseIAAaLQAaIAAaLeads 27/04/2020 18:06 <DIR> aBAsketAnalysisTest_2020-4-27_11-13-36 27/04/2020 18:06 <DIR> aBAsketAnalysisTest_2020-4-27_11-13-36_Alternative 07/03/2020 20:22 <DIR> aClio_2020-3-7_19-22-5 04/05/2020 10:38 <DIR> aCovid19IAAaCitiesAbove50K_2020-5-4_10-38-48 17/03/2020 18:49 <DIR> aDataflixTechnologiesXwAaHemaSaiKanakamedalaXwAaECDATA 06/03/2020 13:35 <DIR> aDataflixTechnologiesXwAaJyothiSaiKrishnaUppalapati 10/03/2020 12:10 <DIR> aDataflixXwAaSreenivas(1) 10/03/2020 12:10 <DIR> aDataflixXwAaSreenivas(1)_Alternative 09/08/2020 16:10 <DIR> aDatesCaseWhen_2020-8-9_16-10-2 07/05/2020 16:44 <DIR> aDay2DayIAAaCompare_2020-5-7_16-44-26 08/02/2020 15:18 <DIR> aDevLQAaSisenseLQAa1LgAa2IAAaExam After... 08/02/2020 22:50 <DIR> ADVATIX_ADILKAPOOR_EC_v3 15/06/2020 15:39 <DIR> Adv Certification - Use Case - Data Security 15/06/2020 15:39 <DIR> Adv Certification - Use Case - Data Security_Alternative 15/06/2020 09:22 <DIR> Adv Certification - Use Case - Leads 27/04/2020 18:06 <DIR> BAsketAnalysisTest 27/04/2020 18:06 <DIR> BAsketAnalysisTest 07/03/2020 20:22 <DIR> Clio 04/05/2020 10:38 <DIR> Covid19 CitiesAbove50K 17/03/2020 18:49 <DIR> DataflixTechnologies_HemaSaiKanakamedala_ECDATA 06/03/2020 13:35 <DIR> DataflixTechnologies_JyothiSaiKrishnaUppalapati 10/03/2020 12:10 <DIR> Dataflix_Sreenivas(1) 10/03/2020 12:10 <DIR> Dataflix_Sreenivas(1)_Alternative 09/08/2020 16:10 <DIR> DatesCaseWhen 07/05/2020 16:44 <DIR> Day2Day Compare 08/02/2020 15:18 <DIR> Dev-Sisense-1.2 Exam Using further Find and Replace we can get the following text: 08/02/2020, ADVATIX_ADILKAPOOR_EC_v3 15/06/2020, Adv Certification - Use Case - Data Security 15/06/2020, Adv Certification - Use Case - Data Security_Alternative 15/06/2020, Adv Certification - Use Case - Leads 27/04/2020, BAsketAnalysisTest 27/04/2020, BAsketAnalysisTest 07/03/2020, Clio 04/05/2020, Covid19 CitiesAbove50K 17/03/2020, DataflixTechnologies_HemaSaiKanakamedala_ECDATA 06/03/2020, DataflixTechnologies_JyothiSaiKrishnaUppalapati 10/03/2020, Dataflix_Sreenivas(1) 10/03/2020, Dataflix_Sreenivas(1)_Alternative 09/08/2020, DatesCaseWhen 07/05/2020, Day2Day Compare 08/02/2020, Dev-Sisense-1.2 Exam We can then save it as a CSV...and from here... use it with APIs for example. Viva clarity 🙂 Tamir