is it possible to do an nexel function based on a different layout on the same screen?
If yes, how?
Thanks and BR
Hi Moritz Funk,
there's the Nexel CrossView functionality that does just that. Here's a link of the help pages Nexel
Are you trying to do something specific?
Ah, thank you: searched in KB and Com, but not there.^^
In addition to this I notify that, as far as I know, the cross view function does not work in multidatabase screens between views linked to different dbs
Hi Ray Martens ,
I have tried to use crossview multiple types by carefully following the Nexel instructions but it never works. It's in the same screen and not referencing other databases. Is there any common mistake I might be making?
Few of the fellow colleagues confirmed that they also have had difficulties with using it.
Hi Edgars Kancans,
I've found out there is one caveat: you can only reference positions within the same range. For example you have two tables. One table/dataview with your nexel function (let's call it target) and one with data you're trying to reference (let's call it source). Target has 10 rows and source only one. If at target you're in row 2, you cannot reference row 2 from source as there is none. You also can't use the possibilities that the range methods of the nexel functions offer - in row 2 you won't get any data from source. What you can do in such a case is add a column (b) in target. In column a you reference source. It might return a result for row 1. In (b) you use a nexel function to reference column (a) from target. In (b) you now are able to use the dynamic range such as 'Range.Up'.
Now this probably does not answer your question. For that I'd need to see a bit what you are doing. Can you post the dataview definitions and the nexel formula(s) you're trying to use?
Thanks Ray Martens for the valuable explanation. I did few tests and concluded that this was the reason why my crossviews failed so often before. For our project we were able to build what we need using Dataflows. Thanks again for your quick response.
Thanks Ray. I'm now implementing NEXEL quite a lot in my models and never knew it could do this. Whilst I do not yet have a use for the crossview functionality, I look forward to finding and implementing one.
A while later...
Ok, so, I've been playing with NEXEL 'Crossview' and I bloody love it, I really do.
After a while I reflected on your 'caveat'
I've found out there is one caveat: you can only reference positions within the same range
It is possible that either I've misunderstood your point or NEXEL was updated for BOARD 10.1.4 because I have used a 'range' reference in column two of my target which draws from the fifth column of my source. I've attached my example model for you, or anyone else, to compare with.
Here is the formula in use at deepest entity level on a dynamic block and drawing from a 'source' dataview with another dynamic block:
Here is the dataview config:
Let me know what you think Ray
Hi Paul Wyatt - Avison Young UK,
I had to open a ticket for that one - this was my question:
I have two dataviews, one target where I'm using a Nexel formula and a referenced dataview called 'Test'. In the target dataview there's the Nexel formula with a cross view like this: =[#Test;@b;*;*;Sum.Total] The Test dataview only has one row and the target dataview has many rows. I'd like to repeat the values from the referenced dataview on all of the rows in the target dataview. The problem is: the first row gets a result, which is correct. all of the other rows get a '#REF!' result. Is this the intended result? How do I get to repeat the values on the other rows?
I hope this explains better what I meant with the range.
Retrieving data ...