Hi all,
I have a query regarding DS and a simple dataset I’d like it to populate on a dashboard.
I’ve got one dimension, two details and a measure being pulled in from the universe with a simple filter to narrow down a timeframe. This query works fine when adding in the datasource, everything populates without issue.
When I assign that datasource to a crosstab with the same initial view as set in the datasource, it pulls in everything except for the measure, which is left blank.
The measure is a straight single integer which is matched to the detail in the query, no calculations are being done at the universe level to get it, it’s coming straight from a view in the DB.
So, could there be:
- a configuration problem in the universe with regards to the measure itself? I’ve looked and it doesn’t seem too complicated but then again, I could be missing something
- Are there limitations to the amount of data a crosstab can show? It’s narrowed down to a 24 hour period so there shouldn’t be more than a thousand rows of data.
- Is it a bug or known issue within DS?
- Am I simply doing it wrong?
I can post up screenshots if need be but I’m hoping the explanation is enough.
Cheers.
Edit: On further reading, some other information I should add is that it’s a universe which has been converted from UNV to UNX. Whether this makes a difference, I don’t yet know but am researching.
scooter7978 (BOB member since 2013-11-01)