on 04-11-2016 7:35 AM
I took up the E-fashion universe with 7 tables. I created an attribute view on ARTICLE_COLOR_LOOKUP.
I am trying to create an analytic view ,using the attribute view in star join( data foundation)
and SHOP_FACTS and ARTICLE_LOOKUP_CRITERIA. I made AMOUNT_SOLD & QUANTITY_SOLD as measures and ARTICLE_CODE as key.
Its getting validated and activated but there is no data. could anyone help me on this?
Thanks in Advance
Hi Rahul,
first of all Attribute Views and Tables have data?
If answer is "YES", Data in Tables and Attribute Views have data matching the join conditions?
Regards,
Muthuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul,
I assume that you have used "Inner Join" to connect the Tables / Views in Data foundation and Logical Join nodes.
Can you please ensure that common data is available in both the tables and Attribute View?
Please Make the Join type to Left Outer Join and check the data Preview. If data is shown then the problem happened because of no common data is available in Tables / Views.
Regards,
Muthuram
There was no common data corresponding to the Join condition I gave.!!
Thanks everyone for your time !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.