cancel
Showing results for 
Search instead for 
Did you mean: 

No data is displayed when I click on raw tab on a analytic view

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

muthuram_shanmugavel2
Contributor
0 Kudos

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

Former Member
0 Kudos

yes its matching.
I even checked the view and  the tables separately .. they hold data !!
but in the analytic view , there is no data !!

 

Former Member
0 Kudos

Hi,

Measures you have selected are only from one table??

Thanks,

Rashi

Former Member
0 Kudos

  yes, they both are from the same table only  " SHOP_FACTS".

muthuram_shanmugavel2
Contributor
0 Kudos

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

Former Member
0 Kudos

I think you need to check your join conditions..in data foundation how did you join the two tables?

Former Member
0 Kudos

yes Muthuram.!!There was some inconsistency in data.No common data was available.!!

It was my fault not analyzing the data properly!

thanks a lot for Your time!!

Answers (1)

Answers (1)

Former Member
0 Kudos

There was no common data corresponding to the Join condition I gave.!!


Thanks everyone for your time !!