private static void UpdateMdxScript() { CubeInfo cubeInfo = new CubeInfo("SCRBSQLDEFRM637", "BICC_PerformanceManagement_DEV"); try { cubeInfo.Connect(); //cubeInfo.getCommands("KPI"); cubeInfo.replaceMdxBlock("KCALC.XPR", @"[Key Figure].[Key Figure Code].&[K.MLB.020] = [Key Figure].[Key Figure Code].&[K.MLB.019] * [Key Figure].[Key Figure Code].&[K.MLB.020];" ); } finally { cubeInfo.Disconnect(); } }
private static void ExportCubeRoleUsers(string role_name) { //CubeInfo cubeInfo = new CubeInfo("ADL1", "ADL_YIP"); CubeInfo cubeInfo = new CubeInfo("SCRBADLDK003869", "OOS"); try { cubeInfo.Connect(); List <string> users = cubeInfo.getUsers(role_name); List <UserEntry> ue = SecurityInfo.getUserEntryList(users); DataExport.ExportCollectionToTextFile(ue, String.Format(@"C:\yrozhok\EMR\Security\{0}.txt", role_name), delegate(double pct) { Console.WriteLine("{0:P2}", pct); }); } finally { cubeInfo.Disconnect(); } }