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();
}
}