August 3, 2015 at 9:55 am
I found a weird behavior with Related() function in one of my tabular projects.
It worked till last week and now its started giving me always single value N/A for all rows.
I checked the Join, it is correct only, I know recently there were new columns added to the table.
Table1 and Table2.
I am bring column10 from table2 to table1 using related field. its always giving me N/A.
I am also bring column 8 from table2 to table1 using related field, its working just fine. Bring all matching vlaues from table2 to table1.
Any suggestions?
Thank You
August 3, 2015 at 11:09 am
Sometimes when changing code I've found that the "Process Default" does not process quite enough. When I get unexplained problems, the first thing I try is to "Process All" on the cube. In my environment, this only takes about 10 minutes so it's no big deal. Hopefully you can do that. If that doesn't help, posting more of the structure would help since there must be some difference to explain why some are working and others are not.
August 7, 2015 at 11:54 am
I did the process All. I double checked the both column data types. Every thing looks good.
You asked about structure. Hope below information make sense to you.
I have a TableFact and TableDim and DateDim. All are joined and its star schema.
Its joined based on Primary Key PrimeKey between TableFact and TableDim.
In TableFact, I used related() function and pulling TableDim column called columnRange (this is string). I also tried pulling columnAge (this is Integer).
when I tried a month ago, both were pulling data correct.
Last week, when I checked randomly, I got to know that the columnRange is giving N/A for most of the cases where as columnAge is doesnt have N/A at all. I am not sure why this is happening last week onwards.
Thank You
August 8, 2015 at 12:45 am
Quick question, could there be more than one row returned? You can check this by filtering the set by the given parameters/predicates.
😎
Further, can you post the actual code you are using?
August 21, 2015 at 1:11 pm
I cannot post code due to security compliance.
I have taken another table and joined to main table and used related function and that solved the issue.
but not able to fix the issue with existing table.
Thank You
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply