Recent Discussions
Copy Prior Year Retained Earnings
Anyone willing to share the process by which you copy prior year accumulated retained earnings to the current year? Is this just handled via data management steps, or do you need a business rule? It does not seem that our implementation partner set this up for us... therefore this account currently is just being imported from our ERPs at the start of the year. This is an issue for our few entities with foreign currency, as the balance continues to translate at the current month closing rate, which we do not want. Appreciate any insight! :-)BWHITAKER17 minutes agoNew Contributor III1View0likes0CommentsCan a Format Template Profile call a Cube View created in a named Workspace?
In v9.0, I have created all my cube views in a named Workspace (i.e. Not Default). I need to attach a single Cube View to a workflow task. In the past, I would create a Form Template Profile which I would then assign to a workflow Form Input task. In v9.0, when I select the Workflow task, I get the message (Unable to open Cube View "mycubeview"). Is this possible, or do I need to create them under the Default workspace or under Application->Presenatation->Cube Views? ThanksRandyThompson3 hours agoNew Contributor III4Views0likes0CommentsNeed help on 2 functions GetSessionDataTable and SetSessionDataTable
Hi All, I am trying to use getSessionDataTable and SetSessionDataTable for loading data from a file placed in harvest folder and then using the table to store it in cube with direct approach. Can anyone provide more insight on these functions? How is it work and if there are any challenge of using these functions?HoneyGulati8 hours agoNew Contributor III8Views0likes1CommentDisable eliminations and Develop Custom elim
Is there anyway we can develop a custom elimination process in the OS and attached with the cube. I see there is a "Custom" option in the cube properties but dont know what this function will do. FinanceFunctionType.ConsolidateElimination. I developed a custom rules which eliminate at first common parent dummy base member and it all ties when I sum but i wanted to get it roll up to Total Entity in USD.pranav462 days agoContributor II18Views0likes2CommentsHow to get FX rate from different source?
I have the request to automate FX rates upload. Rates are stored in DWH (Data warehouse) and that would be easy if I could simply connect there. Unfortunately DWH team doesn't allow it, instead of it they can push their FX rates into my database. Any idea how can I get them such access? Thanks!SolvedKamila3 days agoContributor121Views0likes10CommentsDiscover parameters not working in guided reporting
Hi Team, In guided reporting, I've attached cube views that contain parameters. Defined global options in guided reporting setting. When I discover parameters, it does not work. Can't see the parameter list.Harshada_284 days agoNew Contributor II3Views0likes0CommentsDynamic Cube services
Hi All, I am trying to explore and use Dynamic cube services for one of the requirements however not sure where to start on this. Could you please help me with some inputs around this if anyone has implemented this ? Thank you.SolvedGaneshk124 days agoNew Contributor1.1KViews0likes8CommentsBooks - Dashboard Report, preview does not show any data. It is blank.
Hi All, Does anybody have experience working with books which has dashboards as a pdf. In books, I have Report and inside it has dashboard report as a type. Why we cannot add dashboards there. It is only showing components list. Also, I am adding component like data adapter, grid, embedded dashboard but it is not working. In preview section it is not showing any report or output.Harshada_285 days agoNew Contributor II25Views0likes2CommentsBI Viewer Not Rendering on Parent Dashboard - v8.5
Hello, I am encountering an error when assigning a BI Viewer to a dashboard in version 8.5. The BI Viewer is sourced from a Cube View MD data adapter. When I run the dashboard to which the BI Viewer is directly assigned, it renders fine. However, when I run the main dashboard attached to my workflow, I receive the following error message. I have done the same process Has anyone encountered something similar before - and if so, was there a fix? I am perplexed, because I've been able to use BI Viewers in child/dependent dashboards without issue.jmohl5 days agoNew Contributor III20Views0likes2CommentsGetDataCell Error in CV
Hi All, Any idea why the formula below won't work in CV? GetDataCell(T#|!Par_Time!| - T#|!Par_Time!|.Prior1) The first column contains the formula, and the second one contains this: T#|!Par_Time!|.Prior1. Regards,SolvedGParreiras6 days agoNew Contributor III13Views0likes1Comment