However accessing EDASERVE via Reporting Servers I can see those metadata under myhome folder.Hanumanasana meaning. I have already Get data properly and created the metadata under myhome folder however when trying to Visualize Data none data is found. If you're not getting data, something else is wrong. Once open, you can right click at the top of the field/column list and sample data. With the My Homespace selected, Click on the big plus sign button, and select "prepare and manage data" - navigate to your My Home app folder, and find your synonym and right click and OPEN. If you've done all of the above, then what I would do is verify the synonym is getting data. However, on the flip side, you might want to allow the FINANCE folks to write reports over the sales data, so you probably should then right click on the FINANCE folder, select properties, SERVER tab, and add the SALES application folder to be in the finance folder's path?ĭoes that make sense? So if you have selected My Workspace, click on the VISUALIZE DATA button, you will have a choice of synonyms to build the visualization over ONLY of the synonyms are in one of the application folders in the My Workspace application path.ĭo you have the TEST DRIVE tutorial? That's a good tutorial to help with all this. Unless you've manually added the finance app folder to the sales app path, they won't see it. But you do not want anyone with access to the SALES workspace to even SEE the finance data set representations. You might create synonyms in the SALES application folder over the sales data. But, you might also create a SALES workspace (and associated application folder). That way, whenever you've selected the FINANCE workspace, you'll see all the synonyms in the FINANCE app folder and away you go. And you can put the data set representations (synonyms) over the finance files/tables in that application folder. For instance, set up a FINANCE workspace (it auto creates an application folder also called FINANCE). In other words, it is usually a best practice to have workspaces that might be shared amongst many people. So, you'd best make sure you've selected My Workspace workspace before doing the VISUALIZE DATA or opening up InfoAssist because you want to ensure that the My Home application's synonyms are included in the prompt to select a synonym!Ĥ) I am not sure I'd get in the habit of using My Workspace and My Home. Any workspace has it's own application path - by design - because you may want to segregate what data set representations (synonyms) people can build reports over in any given workspace. Why? Because a workspace's application path is similar to a library list in IBM i. For example, if you are in a workspace called Db2 Web Query Training, and you wanted to build a report or visualization over a synonym in My Home, you would first need to right click on the Db2 Web Query Training workspace, select properties, select the SERVER tab, and then make sure My Home is selected. That is because the workspace's path of applications does not include the My Home application folder. Select that, and you should see your synonym and away you go.ģ) If you were in a different workspace when you clicked on Visualize Data, then you might not see the My Home application folder. There are some important organizational and navigational aspects to understand as you start working with your content.ġ) on my 2.3.0 system, if I first go to WORKSPACES and select My Workspace, and then do a GET DATA to create a new synonym, it will place the created synonym in My Home APPLICATION (or APPLICATION FOLDER) and auto load Designer pointing to your newly created synonym.Ģ) If, after your synonym is created and you're back on the home page, if you have My Workspace selected and click on the VISUALIZE DATA button, designer opens and you're prompted for a synonym to choose to represent the data set you want to build your visualization/report over. What version of Db2 Web Query are you working with (I assume 2.3.0 - but you can do a WRKWEBQRY to find out).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |