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<br/>15/06/2020 15:39 <DIR> aAdvIAAaCertificationIAAaLQAaIAAaUseIAAaCaseIAAaLQAaIAAaDataIAAaSecurity<br/>15/06/2020 15:39 <DIR> aAdvIAAaCertificationIAAaLQAaIAAaUseIAAaCaseIAAaLQAaIAAaDataIAAaSecurity_Alternative<br/>15/06/2020 09:22 <DIR> aAdvIAAaCertificationIAAaLQAaIAAaUseIAAaCaseIAAaLQAaIAAaLeads<br/>27/04/2020 18:06 <DIR> aBAsketAnalysisTest_2020-4-27_11-13-36<br/>27/04/2020 18:06 <DIR> aBAsketAnalysisTest_2020-4-27_11-13-36_Alternative<br/>07/03/2020 20:22 <DIR> aClio_2020-3-7_19-22-5<br/>04/05/2020 10:38 <DIR> aCovid19IAAaCitiesAbove50K_2020-5-4_10-38-48<br/>17/03/2020 18:49 <DIR> aDataflixTechnologiesXwAaHemaSaiKanakamedalaXwAaECDATA<br/>06/03/2020 13:35 <DIR> aDataflixTechnologiesXwAaJyothiSaiKrishnaUppalapati<br/>10/03/2020 12:10 <DIR> aDataflixXwAaSreenivas(1)<br/>10/03/2020 12:10 <DIR> aDataflixXwAaSreenivas(1)_Alternative<br/>09/08/2020 16:10 <DIR> aDatesCaseWhen_2020-8-9_16-10-2<br/>07/05/2020 16:44 <DIR> aDay2DayIAAaCompare_2020-5-7_16-44-26<br/>08/02/2020 15:18 <DIR> aDevLQAaSisenseLQAa1LgAa2IAAaExam
After...
08/02/2020 22:50 <DIR> ADVATIX_ADILKAPOOR_EC_v3<br/>15/06/2020 15:39 <DIR> Adv Certification - Use Case - Data Security<br/>15/06/2020 15:39 <DIR> Adv Certification - Use Case - Data Security_Alternative<br/>15/06/2020 09:22 <DIR> Adv Certification - Use Case - Leads<br/>27/04/2020 18:06 <DIR> BAsketAnalysisTest<br/>27/04/2020 18:06 <DIR> BAsketAnalysisTest<br/>07/03/2020 20:22 <DIR> Clio<br/>04/05/2020 10:38 <DIR> Covid19 CitiesAbove50K<br/>17/03/2020 18:49 <DIR> DataflixTechnologies_HemaSaiKanakamedala_ECDATA<br/>06/03/2020 13:35 <DIR> DataflixTechnologies_JyothiSaiKrishnaUppalapati<br/>10/03/2020 12:10 <DIR> Dataflix_Sreenivas(1)<br/>10/03/2020 12:10 <DIR> Dataflix_Sreenivas(1)_Alternative<br/>09/08/2020 16:10 <DIR> DatesCaseWhen<br/>07/05/2020 16:44 <DIR> Day2Day Compare<br/>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<br/>15/06/2020, Adv Certification - Use Case - Data Security<br/>15/06/2020, Adv Certification - Use Case - Data Security_Alternative<br/>15/06/2020, Adv Certification - Use Case - Leads<br/>27/04/2020, BAsketAnalysisTest<br/>27/04/2020, BAsketAnalysisTest<br/>07/03/2020, Clio<br/>04/05/2020, Covid19 CitiesAbove50K<br/>17/03/2020, DataflixTechnologies_HemaSaiKanakamedala_ECDATA<br/>06/03/2020, DataflixTechnologies_JyothiSaiKrishnaUppalapati<br/>10/03/2020, Dataflix_Sreenivas(1)<br/>10/03/2020, Dataflix_Sreenivas(1)_Alternative<br/>09/08/2020, DatesCaseWhen<br/>07/05/2020, Day2Day Compare<br/>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
