SQL query to retrieve base members of a hierarchy
Hi, All Just wanted to share a SQL query I wrote to retrieve base members and parent of a given hierarchy from within a dashboard grid. (Note that the parameter supplies the member ID of the top member in the chosen hierarchy.) Any thoughts on how to improve are welcome! With TEST AS (SELECT childid, parentID, dimtypeid, 0 AS level FROM relationship WHERE parentid = |!SelectDimension!| UNION ALL SELECT ft.childid, ft.parentID, ft.dimtypeID, level + 1 FROM relationship ft JOIN TEST d ON ft.parentid = d.childid ) SELECT m.name As Child_Name, m.description as Child_Description, P.name AS Parent_Name, Description as Parent_Description FROM TEST d JOIN relationship a ON d.parentid = a.parentid JOIN member AS M ON a.childID = m.memberid JOIN member as P on d.parentid = p.memberid where NOT EXISTS ( SELECT NULL FROM TEST d WHERE d.parentID = m.memberID ) group by m.name, m.description, P.name, p.description
Primary and secondary axis align 0 point
Hi everybody, Below you can see a graph created for a client. A question coming from them is that they want to align the 0 points (highlighted) of both the primary (left) axis and the secondary (right) axis. I've tried (amongst others) to change the visual and whole range, scaling options but it doesn't seem to change anything. Does anybody know if it is possible to align the 0 points? Thanks! Floris
BI Viewer - Creating a clustered column line chart
Hey All, I'm trying to add a column (bar) chart on top of this line chart. But I want it to reference and add a dollar based stats account (e.g. Avg Fleet Total) bar chart. I noticed there is a way to add a second axis on the right - so wondering if I can have two charts on the same pane. Appreciate the help folks. Thank you!
SQL Table Editor - Query - External DataBase
SOURCE: ONESTREAM CHAMPIONS Hi Team, do we need to put some specific settings to connect the External DataBase… when we are connecting it via SQL Table Editor. i am getting the below mentioned error ( where as the same connection works via Data Adaptor ) Subledgers _ External.png977×467 21.7 KB Regards and Thanks Darpan Bhansali
