Each level is a column from a single table. The table looks like this: Region | Dept | Employee | Sales Amt Region 1 | Sales | John Doe | 55 Region 1 | HR | Bob Smith | 110 Region 1 | HR | Chris Jones | 85 Region 1 | Marketing | Arnold Port | 33 Region 2 | Sales | Sid Nancy | 331 Region 2 | HR | Tammy Hughes | 231 Region 2…

I am still trying to resolve this issue. If there are any other ideas, please provide. Thank you.

I made sure each level has a key including each previous level. Still having the same issue.

Sorry. That was just a typo. I cannot copy and paste. I had to type out the formula by hand. Changing ID to "ID" produced the same results: "General Error near <select>"

That option is not possible due to my circumstances.

Thanks Christian. It turns out that I had a <prompts> element at the bottom of my xml with the incorrect subject area.

Nothing too complicated. I only want the sum of sales for the year and the profit for the year. So, one line per year per vehicle type. i.e. type year sale_price profit car 2012 16000 500 car 2013 19000 600 boat 2012 42000 1200 boat 2013 58000 1400 bike 2012 8700 200 bike 2013 10300 300

Could you point me in the direction of some documentation or a tutorial? Thanks.

Thomas, thanks for the response but you might as well have been replying in Greek. I have no idea what any of that means. Can you point me to a website that may be able to enlighten me?

Does anyone have any additional information or possible tips/tricks to help me accomplish this? Thank you

Any additional information on how to get Object Types would be helpful. I can get a list of items and it's children, but I don't see a way of determining whether the item is a Dashboard, Prompt, Analysis, etc. I found the getObjectTypes method in the documentation but it is not part of the WebService on 11.1.1.7. Please…

Thank you. I am able to access the catalog using the webservice. However, there is supposed to be a method that will getObjectTypes. This method is not found in the WebCatalogService service. Does anyone know where this method went and what I can use to access the Object Types? Thank you again. Raymond

Are there any basic examples out there?

I only want to get objects out of the catalog. My front end will ask the user to select the object type (Dashboard Prompt, Analysis, Dashboard Page, etc.). Once selected, I need to return a list of the selected object type. Nothing else needs to be done with the catalog.