Home > Default > Query AW with OLAP DML

Query AW with OLAP DML

November 30Hits:0
Advertisement
Hi,
i would like to access and query my cube. Is it possible to do it without building a view? Can I do it just using OLAP DML? Where can I find an example?
thank you

Answers

Yes. You can query using OLAP DML. Try this in the OLAP Worksheet (within the AWM)
(Assuming you have attached to the AW)
allstat
limit dimName1 to 'dimValue1'
limit dimName2 to 'dimValue2'
report measName1
Hope this helps,
Swapan.

Read other 3 answers

Tags:

Related Articles

  • Query AW with OLAP DMLNovember 30

    Hi, i would like to access and query my cube. Is it possible to do it without building a view? Can I do it just using OLAP DML? Where can I find an example? thank youYes. You can query using OLAP DML. Try this in the OLAP Worksheet (within the AWM) (

  • Tip: Improving The Performance Of OLAP DML Table InsertsNovember 30

    Quick Oracle OLAP Tip: If you need to write the contents of a variable, or a group of variables, to a relational table, you would normally use the SQL INSERT command. Normal practice is to loop round all of the variables' dimension values, inserting

  • CAN i CALL OLAP DML THROUGH JDBC IN JAVA PROGRAMNovember 30

    I HAVE ORACLE V 9.2.0.1.0 AND AFTER CREATING A CUBE FROM ENTERPRISE CONSOLE I HAVE TO GO WITH EITHER SQL PACKAGES OR OLAP DML PROGRAMS ,SO PLS GIVE ME PROPER WAY AND LINK OF SOURCES TO WORK WITH OLAP DML IN JAVA PROGRAMS CAN I USE AS PREPARED STATEME

  • 11g - Listing Workspaces in OLAP DMLNovember 30

    Hi All, Is there a way in OLAP worksheet, to list all the workspaces accessible to the user? It can be done by querying the data dictionary - "select * from all_aws;" but this information should be available in AW and OLAP DML too? Regards, Neel

  • How do I view data from OLAP DML program or statement?October 11

    Hi I'm struggling to find any information on this topic anywhere on the net: How to view data produced by an Oracle OLAP DML program or statement. Background : I am using the latest AWM to create and maintain dimensions, cubes and measures. However,

  • Creating a Cube using pure OLAP DMLOctober 11

    This should be quite simple, but neither reading OLAP_*.pdf nor googling helped me, so maybe you can give me a hint where to look: I want to create dimensions, populate them, create a cube, and finally populate it, using just OLAP DML (i.e. no DBMS_A

  • Creating variables in OLAP DML - 11gOctober 11

    Hi Experts, My understanding is that the OLAP metadata is exposed to GUI via formulas only. if I create a variable in OLAP DML worksheet, is it possible to expose it to cube view, and awm by formulas/programs etc? Kind RegardsIn OLAP Worksheet you ca

  • [OLAP DML] display on screen the output while the program is runningOctober 11

    Hi, I'm running a script in AWM that is quite long, and I've placed some few 'show' so that I know what the program is doing, but it won't show on the screen the outputs until the program ends. I guess it writes all the outputs in a kind of buffer an

  • Universe Designer vs BEx query - Can't see the query in the OLAP Cubes listNovember 30

    Hello Experts, We are facing a rather strange issue: While creating a connection to an existing BEx query - which wasn't being used by BO before - we aren't able to see that one query in a long list of available multiproviders/queries on the universe

  • How to generate OLAP DML code or CWM2 code outside of workspace manager 10gNovember 30

    I am using AWM 10.2, where I am creating cubes and dimensions etc. I can export the workspace into XML, but i want more, i want to generate definition of my OLAP, i want to see OLAP DML code for creating my workspace. Anybod has an idea ? 1) How can

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.695 s.