7 Replies Latest reply: Aug 3, 2016 7:23 AM by arul settu RSS

    Hierarchy pls

    Govind Ramchetty

      Hi

      Can you please let me know what is the steps to create reports and dashboards.

       

      and

      How can i join 2 tables (Left out)

      I have 2 tables A and B. .

       

      Thanks

      Govind

        • Re: Hierarchy pls
          arul settu

          1.creating dashboards is purely based on requirement only.

           

          2. Table1:

          load a

                 b

                 c

          from table1;

           

          left join(Table1)

          Table2:

          load a

                 b

                 b

          from table2;

            • Re: Hierarchy pls
              Govind Ramchetty

              How and where can i give this condition.I am new to sense can you please give me steps

                • Re: Hierarchy pls
                  arul settu

                  go to data load editor and use above query

                    • Re: Hierarchy pls
                      Govind Ramchetty

                      [GL_Fact]:
                      LOAD
                      [Expense_GL] AS [Expense_GL],
                      [Posted Date] AS [Posted Date-Year];
                      LOAD [Expense_GL],
                      [Posted Date]
                      FROM [lib://Datasources/Expense_Report.xlsx]
                      (ooxml, embedded labels, table is GL_Fact);

                       

                      Left join [GL_Fact]

                       

                      [Expenses_Fact]:
                      LOAD
                      [Expense_Ex] AS [Expense_Ex],
                      [Year] AS [Posted Date-Year];
                      LOAD [Expense_Ex],
                      [Year]
                      FROM [lib://Datasources/Expense_Report.xlsx]
                      (ooxml, embedded labels, table is Expenses_Fact);

                       

                      I am getting error..

                        • Re: Hierarchy pls
                          Govind Ramchetty

                          [GL_Fact]:
                          LOAD
                          [Expense_GL] AS [Expense_GL],
                          [Posted Date] AS [Posted Date-Year];
                          LOAD [Expense_GL],
                          [Posted Date]
                          FROM [lib://Datasources/Expense_Report.xlsx]
                          (ooxml, embedded labels, table is GL_Fact);

                          Left join

                          [Expenses_Fact]:
                          LOAD
                          [Expense_Ex] AS [Expense_Ex],
                          [Year] AS [Posted Date-Year];
                          LOAD [Expense_Ex],
                          [Year]
                          FROM [lib://Datasources/Expense_Report.xlsx]
                          (ooxml, embedded labels, table is Expenses_Fact);

                           

                          Now looks ok but in my data model viewer I can see single table instead of 2 tables.but I can see both tables fields.