I will send you source code. After entering the query and clicking on export to excel its giving a message that no application is associated with the specified file for this operation but when I am trying to open it from a diferent server its allowing to login and get the result of the previous server where its giving error. You can change the limit using option TOP: e.g. . You can also dynamically override the default settings for a query by using the Import dialog box which displays after you selectClose & LoadTo. AdminTools Session should be opened with Administrator account if possible, since this account has faster security rights check than with standard account (even compared to a user part of Administrators group). An Error occured in sending the commanf to the application. Hi ! its with enterprise id. Yes, the tool requires .NET 3.5. 1. Any output can also be retrieved by a WebI document. To close the Power Pivot window, select File > Close. Security profiles,but not able to get the name of the each DATA Security Profile name from the query. > Does it run standalone? Let me know if you need help with this. Thanks I see all content too now! You can use the DB system tables like v$sql for oracle. To preview the base data returned by a query, click the Refresh button: The combination of a document ID and In Excel, select Data > Data & Connections > Queries tab, right click the query and select Properties, select the Definition tab in the Properties dialog box, and then select Edit Query. Really an Excellent Tool! How do I get a list of Parameter Names, and their Types (string or numeric) using SQL ? Query Builder can be found at the below URL http://MyServer:Port/AdminTools. I want to know the query for the query builder. I will check it. WebIn the Export - Excel Spreadsheet dialog box, review the suggested file name for the Excel workbook (Access uses the name of the source object). Alternatively, you can try Skyvia Query Excel Add-in, the Clear this option if you prefer to do this on your own. SI_PROCESSINFO.SI_WEBI_PROMPTS, SI_PROCESSINFO.SI_FILES, SI_PROCESSINFO.SI_PROMPTS FROM CI_INFOOBJECTS, WHERE SI_KIND = WEBI and SI_INSTANCE = 0 and, To extract all the report names from specific folder, SELECT SI_ID,SI_NAME,SI_PARENT_FOLDER,SI_FILES, FROM CI_INFOOBJECTS WHERE SI_KIND = WEBI AND SI_INSTANCE = 0 AND SI_ANCESTOR = [SI_ID OF THE FOLDER], To get Reports those are spanning multiple universes, SELECT SI_ID, SI_KIND, SI_NAME FROM CI_INFOOBJECTS WHERE SI_UNIVERSE.SI_TOTAL>1, To list all the events and corresponding event file location, SELECT SI_ID, SI_NAME, SI_FEATURES FROM CI_SYSTEMOBJECTS WHERE SI_KIND= Event, To list all Scheduled reports based on event, SELECT SI_NAME, SI_SCHEDULEINFO FROM CI_INFOOBJECTS, WHERE SI_RUNNABLE_OBJECT = 1 AND SI_SCHEDULEINFO.SI_DEPENDENCIES.SI_TOTAL > 0, SELECT SI_NAME, SI_OWNER, SI_AUTHOR, SI_SCHEDULEINFO, SI_PARENT_FOLDER FROM CI_INFOOBJECTS WHERE SI_KIND = WEBI AND SI_CHILDREN = 0 AND SI_SCHEDULEINFO.SI_SCHED_NOW = 0, To get the list of all reports scheduled daily excluding Paused. It may take a few seconds to reclaim memory. but, I have an issue, using with BO XI R2 SP5 while trying to login I have the message box could not login and nothing more My credential are OK and tested on the CMC webpage thanks for your help ! Querying the relationships between different objects of the tables requires specific Query Builder knowledge. I loaded it onto my computer, as opposed to just running it from this site, and the error went away. I am also getting the same error File is in used by another process. Query Builder is a tool available in SAP BusinessObjects since Crystal Enterprise 8.5 that allows you to understand what content exists in the CMS (Central However I run into the same error:Could not save file, file is used by another process. Text Format, Hi Dymytri There are a few doubts I wanted to ask and you seem to be an expert on the subject. Hello Manikandan, I work in Dallas and I thank you for writing this blog post. There is one tool called BI clever. A third-party tool will also give you the possibility to carry out complex requests that arent possible with Query Builder. The default connection is using port 8080 we use 9100. There are two ways to do this. You can either create a query from imported data or create a blank query. Dear Matthew, again a useful page/info by you, I can't open/view the note 1895241. This tool could help me significantly. Thanks Dmytro for your response. WebNext, we need to find the names of queries (or "data providers") contained within this document: Open the WebIntelligence document and enter Design mode. Alerting is not available for unauthorized users, Right click and copy the link to share this comment. SELECT SI_ID, SI_NAME, SI_PROMPTS.SI_USER FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport', I try the above and it does not return SI_PROMPTS.SI_USER. If you know the name or cuid of the missing folder that would be helpful. http://www.reportminer.com/products/rptminersuite.shtml. I am having the same question, Can you recommend a tool or a way to get the report's query. On a more functional level, we are able to document all objects in your environment, for example, the permissions, users and groups, universes, user connections, and are able to run impact analysis and understand what is used and not used. what i am asking, one of our developer had used "image from address" in Appearance option in format cell. Hello All, We have been play around with the Query Builder a bit and noticed an oddity I guess. These query builder posts have been extremely beneficial after being thrown into the SAP BOBJ admin world. Also a query to get information on who uses a particular report. I have been using Query Builder only for a very short while. Or you can select Home and then select a command in the New Query group. With 360Suite we can help you explore your whole content in a way that allows you to interact with it, providing you with a bigger picture of your content landscape. Legal Disclosure |
With the graphical interface, users can create requests by using predefined objects and filters, rather than having to type in the technical terms. Please help. The default behavior is to detect them. Contact us today and one of our experts will help you. I am also interested in this tool. Same result. Your help in this matter will be highly appreciated. In the Power Query Editor, select Home > Close & Load > Close & Load. Any suggestions? SELECT * FROM CI_SYSTEMOBJECTS, CI_APPOBJECTS, CI_INFOOBJECTS WHERE SI PARENTID IN (53,59), https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2+SP3. I am using below query: SELECT SI_ID,SI_NAME, LAST_RUN_TIME FROM CI_INFOOBJECTS WHERE SI_PARENT_FOLDER = 5698. there isn't, the tool is not built for exporting, however CMS DB driver now allows you to build universes on top of repository and report of them. CI_APPOBJECTS information about universes. On the other hand: Depending on the delimiter char used, the method of opening the file in Excel might be the problem: Restart Excel and choose "File > Open > Remove all references to the libraries and reattach them. It is great tool, love it. setup the odbc connector on the users pc, rename and database to .accdr, put it on a file share and install the ms access runtime (free) on their pcs. SELECT SI_ID,SI_NAME,SI_PARENT_FOLDER,SI_FILES FROM CI_INFOOBJECTS However, there are only three tables and there are vast amounts of information stored in each one, making retrieving the data very difficult. I need to do this, as the BO4 REST service to retrieve this information takes 2-4 minutes to run, even with "lovInfo=false" at the end of the URL: http://YOUR_SERVER_NAME:6405/biprws/raylight/v1/documents/11729/parameters?lovInfo=false. All the users within and under a particular group. You may want to just start from scratch. and includes a section listing Process Info (including the report's parameter names, etc). How does it interface with the server? What I have tried so far (Image is Embedded and not from a Database or External): Hi, I want to use the tool for BO XI R2. The purpose of the tool is to simplify building CMS metadata queries and providepossiblyto export the result to Excel. Alternatively, on thePower Query Editor ribbon select Query > Load To. To edit a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. I noticed this behavior when you use this in Mac. 2) Install the tools to completly new PC. To avoid confusion, its important to know which environment you are currently in, Excel or Power Query, at any point in time. I am trying to find the right SQL to return the SI_User field contents from the SI_Prompts of Crystal Reports. WebBusinessObjects Query builder 708 Views Follow RSS Feed List all the Public folders (including Subfolders) and which UserGroups has access to those folders/subfolders. Congrats! When prompted upload this file to create a new business object by dragging and dropping the file in the blue At Xoomworks BI we view the GB&Smith 360Suite of tools as administration intelligence for SAP BusinessObjects. Great tool! What authentication are you using? In the Business Object menu icon and select Data Manager from the dropdown to open the import tool. This will be handy for those who searching for Query Builder Queries. Its a one-shot process. It would be great to have their paths as well (folder location). In a few months, SAP Community will switch to SAP Universal ID as the only option to login. We provide a library of WebI documents in order to efficiently query the metadata it aggregates. (Here limited to only the Public folders), select si_name from ci_infoobjects where si_parentid=23 and IsAllowed(
Usa Boxing Olympic Trials,
Simon Sadler Blackpool,
How To Break Your Waist When Dancing,
Articles B
