Beispiel #1
0
        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();
            }
        }
Beispiel #2
0
        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();
            }
        }