Recent Discussions
Dashboard: Combo box with bound parameter
Hi, I have set up a combo box that uses Bound List parameter "WfProfile_AssignedEntities" with defaul value WFProfile_AssignedEntities. Even though the default value is set, when I use it in the dashboard, it default to empty space and a drop-down where I need to pick up my workflow profile assigned entity. How can I make to show a workflow entity without needing to go in drop-down and pick up it from there?LarysaZ3 years agoNew Contributor II22KViews0likes48CommentsHow to install Excel addin?
Hi, I need the excel add-in. Can you please help me with the same. Thanksishaanand3 years agoNew Contributor II13KViews0likes1CommentCombobox Multiple select option.
Is it possible to have multi select option in Combo box ( Dashboard component)? Thanks & Regards, Madesh KSolvedMadesh4 years agoNew Contributor III11KViews0likes20CommentsConditional Formatting in CubeView in the "annotation" or other "Text" cell
I would like to apply conditional formatting to a Cube View column that contains "Annotation", "Variance Explanation" or other textual data. I have tried IsNoData and "CellAmount" conditions, but with no success. I would appreciate any direction. Thank you! Yan SavinskySolvedYanSavinsky4 years agoNew Contributor III11KViews0likes20CommentsGroup Columns/Excel Outline in Columns on Cube Views
Hello: Has anyone had any success with grouping columns in a cube view in a report linked to excel, or grouping them as they export? Of course in the data explorer version you can use the tree function and toggle the row expansion mode to get the intended effect, and in rows you have the excel outline settings you can play with. However, there doesn't seem to be a way to manage this using settings. And obviously if you format the cube view when linked them refreshed the column grouping goes away. Interested to hear and thanks!SolvedJamesKirkby4 years agoNew Contributor III9.9KViews0likes17CommentsLoad comments to the cells through Data input or Forms
Team Is there a way we can add long text like comments to the cells through Forms? Am trying to build a cube view with data and comments to it which is visible on view rather than adding it as "note" or "attachments". Please see the sample image below on the requirement.SolvedSKVK3 years agoNew Contributor III9.8KViews1like15CommentsRetrieve Parent property
SOURCE: ONESTREAM CHAMPIONS Hi All, I am trying to find a way to create a report that shows the Entity and the Parent in a column next to it. I tried to do this by using the functions =XFGetMemberProperty() and =XFGetRelationshipProperty(), both returns an error when I try. =XFGetRelationshipProperty(“Entity”,"",B15,“Parent”,"","") returns “#ERROR: Parent” =XFGetRelationshipProperty(“Entity”,B16,"",“Parent”,"","") returns “#ERROR: Member Name” =XFGetRelationshipProperty(“Entity”,B17,"",“Parent”,“ACTUAL”,“2021M1”) returns “#ERROR: Member Name” =XFGetRelationshipProperty(“Entity”,B4,B5,“Parent”,"","") returns “#ERROR: Parent” =XFGetMemberProperty(“Entity”,B13,“Parent”,“Finance”,“Actual”,“2021M1”) returns “#ERROR: Finance” =XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent” =XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent” =XFGetMemberProperty(“Entity”,B11,“Parent”,"","",“2021M1”) returns “#ERROR: Parent” =XFGetMemberProperty(“Entity”,B12,“Parent”,"","","") returns “#ERROR: Parent” as a reference, I tried the same function on “currency” and that works. =XFGetMemberProperty(“Entity”,B21,“Currency”,"","","") returns “EUR” I am assuming that the complexity lies in the fact that the parent could vary in time (?) . I hope some body can help on this thanks. Philpling4 years agoNew Contributor II9KViews0likes7CommentsReporting - Books - File (xfDoc)
Hello, I would like to create a report book that includes several cube views and an xfdoc (ppt cover page). I added the xfdoc as an application database file and pointed it to the working URL. However, when I run the report book I get a blank page. I can't figure out how to get it to render the File (xfDoc). It does render all the cube views as expected. And I confirmed that my standalone xfdoc is working as well. Thanks, SeanSolvedCAIGuySeanF3 years agoContributor8.9KViews0likes12Comments