Ejemplo n.º 1
0
        public static void Main(string[] args)
        {
            DataSet   dataSet      = new DataSet();
            DataTable TTable       = dataSet.Tables.Add("table");
            DataTable TCol         = dataSet.Tables.Add("columns");
            string    varSeparator = "\t";
            Proc      p            = new Proc();

            p.CreateLog("d:\\DW_TABLE.txt");

            string          connectionString  = "provider=MSDAORA;data source=Mer;user id=c;password=c";
            OleDbConnection myOleDbConnection = new OleDbConnection(connectionString);


            OleDbDataAdapter adapterTable =
                new OleDbDataAdapter("select t.TABLE_NAME,t.COMMENTS,t.owner from sys.all_tab_comments t where  t.owner = 'DW' and Table_type='TABLE'  union " +
                                     "select t.TABLE_NAME,substr(t.COMMENTS,4),t.owner from sys.all_tab_comments t where  t.owner = 'C' and Table_type='TABLE' and  substr(t.COMMENTS,1,3)='DW;' " +
                                     "union select t.TABLE_NAME,t.COMMENTS,t.owner from sys.all_tab_comments t where  t.owner = 'SHAKH'  and TABLE_NAME='MIN_MAX_REST'", myOleDbConnection);

            adapterTable.Fill(TTable);
            p.Log("Таблички");
            foreach (DataRow row in TTable.Rows)
            {
                p.Log(row[2].ToString() + '.' + row[0].ToString() + varSeparator + row[1].ToString());
                string varSQL = "select col.COLUMN_NAME, col.DATA_TYPE, com.Comments " +
                                "from sys.all_tab_columns col, sys.all_col_comments com " +
                                "where col.owner = '" + row[2].ToString() + "' and col.table_name = '" + row[0].ToString() + "' " +
                                "and com.Owner (+) = col.owner " +
                                "and com.Table_Name (+) = col.table_name " +
                                "and com.Column_Name (+) = col.Column_Name " +
                                "order by col.column_id ";


                OleDbDataAdapter adapterCol =
                    new OleDbDataAdapter(varSQL, myOleDbConnection);

                adapterCol.Fill(TCol);
                foreach (DataRow rowCol in TCol.Rows)
                {
                    p.Log(varSeparator + rowCol[0].ToString() + varSeparator + rowCol[1].ToString() + varSeparator + rowCol[2].ToString());
                }
                TCol.Clear();
//      Console.WriteLine(row[0].ToString() );
//      Console.WriteLine(row[1].ToString()) ;
            }
            p.Log("Представлення");
            adapterTable =
                new OleDbDataAdapter("select t.TABLE_NAME,t.COMMENTS,t.owner from sys.all_tab_comments t where  t.owner = 'DW' and Table_type='VIEW'", myOleDbConnection);
            TTable.Clear();
            adapterTable.Fill(TTable);
            foreach (DataRow row in TTable.Rows)
            {
                p.Log(row[2].ToString() + '.' + row[0].ToString() + varSeparator + row[1].ToString());
            }


            myOleDbConnection.Close();

            p.CloseLog();
            //Console.ReadLine();
        }
Ejemplo n.º 2
0
        public static void Main(string[] args)
        {
            string varSRV  = "SRV-OLAP";
            string varDB   = "dw_olap";
            string varCube = "Рух товарів";

            for (int i = 0; i < args.Length; i++)
            {
                if (args[i].ToUpper().StartsWith("/SERVER:"))
                {
                    varSRV = args[i].Substring(8);
                }
                else if (args[i].ToUpper().StartsWith("/DB:"))
                {
                    varDB = args[i].Substring(4);
                }
                else if (args[i].ToUpper().StartsWith("/CUBE:"))
                {
                    varCube = args[i].Substring(6);
                }
            }

            string varSeparator = "\t";
            Proc   p            = new Proc();

            p.CreateLog("d:\\Cube_" + varCube + ".txt");
            Microsoft.AnalysisServices.Server s = new Microsoft.AnalysisServices.Server();
            s.Connect(@"Data Source=" + varSRV + ";Provider=msolap;Initial Catalog=" + varDB);
            Microsoft.AnalysisServices.Database d = s.Databases.FindByName(varDB);
            Microsoft.AnalysisServices.Cube     c = d.Cubes.FindByName(varCube);
            p.Log("База:" + varDB + " Куб:" + varCube);
            p.Log("Розмірності");
            foreach (Microsoft.AnalysisServices.CubeDimension dim in c.Dimensions)
            {
                p.Log(dim.Name + varSeparator + dim.DimensionID + varSeparator + dim.Description);
                foreach (Microsoft.AnalysisServices.CubeAttribute attr in dim.Attributes)
                {
                    p.Log(varSeparator + attr.Attribute + varSeparator + attr.AttributeID + "\t" + attr.Attribute.Description);
                }
            }
            p.Log("Групи мір");
            foreach (Microsoft.AnalysisServices.MeasureGroup mg in c.MeasureGroups)
            {
                p.Log(mg.Name + varSeparator + mg.ID + varSeparator + mg.Description);
                foreach (Microsoft.AnalysisServices.Measure m in mg.Measures)
                {
                    p.Log(varSeparator + m.ID + varSeparator + m.Name + varSeparator + m.Description);
                }
            }

            p.Log("Калькульовані міри");

            Microsoft.AnalysisServices.AdomdClient.AdomdConnection cn = new Microsoft.AnalysisServices.AdomdClient.AdomdConnection("Data Source=" + varSRV + ";Provider=msolap;Initial Catalog=" + varDB);
            cn.Open();

            /*foreach ( Microsoft.AnalysisServices.AdomdClient.CubeDef tt in cn.Cubes)
             *  p.Log(tt.Name+varSeparator+tt.Caption );*/
            try
            {
                foreach (Microsoft.AnalysisServices.AdomdClient.Measure m in cn.Cubes[varCube].Measures)
                {
                    if (string.IsNullOrEmpty(m.Expression) == false)
                    {
                        p.Log(m.UniqueName + varSeparator); //+m.Expression +varSeparator+ m.Description );
                    }
                }
                //Console.WriteLine("{0}: {1}",m.UniqueName,m.Expression );
            }
            catch {            }
            finally { cn.Close(); };
            //Console.ReadLine();


            p.CloseLog();
        }