Hierarchy pls

[#1]

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

[arulsettu]

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;

[#3]

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

[arulsettu]

go to data load editor and use above query

[#5]

[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..

[#6]

[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.

[arulsettu · Accepted solution]

join will make two tables into single table. change the field names in second table into first table name(similar names)