02-16-2024 12:06 PM - last edited on 02-19-2024 06:57 AM by JackLacava
I'm running a SQL query to display the data as if it were a QView, but I realized that the table I was using didn't contain the values it should.
SELECT
EntityId,
UD1Id,
UD4Id,
TimeId,
ICId,
Amount,
FlowId,
ConsId
FROM
DataEntryAuditCell
WHERE
ScenarioId = (
SELECT
MemberId
FROM
Member
WHERE
Name = '|WFScenario|'
)
AND CubeId = 4
AND ICId != -999
AND AccountId = 17826015
AND Amount != 0
AND FlowId IN (1048639,-999)
AND UD1Id != -999
AND UD4Id != -999
The reason for using SQL is to facilitate user access to that specific information, as a QView wouldn't display everything according to the required permissions, which in this case doesn't apply as it's very specific information.
So it would be helpful if you could tell me which table or tables I can use to achieve the same result as I would see when using a QView.
02-19-2024 04:55 AM
I guess by "QView" you mean a Cube View?
The reasons for differences between raw SQL values and Cube View displayed values can be many - formatting , DynamicCalc intersections, ConditionalInput rules, access rules...
I think your problem really is this: "a QView wouldn't display everything according to the required permissions, which in this case [you think it] doesn't apply" You're trying to bypass OneStream security, instead of working with it. The right way to go about this is figuring out why that is, and address it the right way. If you can't touch anything in that cube setup, for example, you could copy the necessary data to a separate cube and apply different security there.
02-28-2024 09:30 AM
Yes, a cube view, but I want to know if there is a way to do it even from a business rule, that is, a business rule that gives me the data of a cube view or the way that the functionality of Excel does.
02-28-2024 09:56 AM - edited 02-28-2024 09:57 AM
You can get data from cubeviews in a few different ways. What you choose will depend on what you want the output to look like.
02-28-2024 11:10 AM - edited 02-28-2024 11:10 AM
How could I do something like quick views in Excel to display information on a dashboard? Since I have more filters than what the cube view allows me (for the row).
02-28-2024 01:02 PM
I'm not sure I understand the question, but if it's about building filters on a Dashboard, you'll have to investigate Bound Parameters and general Dashboard design. It's a vast topic, there is a book about it.
02-28-2024 06:08 PM
I created the cube view and yes, I encountered that security issue, so how could I go about displaying the information to someone who couldn’t see it?