nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Siemens Community Catalyst Program

The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.

Nominate Now

Please Help about OLAP in rapid miner

blue534

hi. I want to do the OLAP with RapidMiner. i have daha in a excel file. and i want to do an OLAP example in rapid miner. how can i find OLAP operators in rapidminer and and how can i do it. please tell me.. thanks.

Find more posts tagged with

AI Studio

Accepted answers

All comments

MariusHelf

There are no dedicated OLAP operators in RapidMiner, but you can basically do everything you like with your data. You may probably find the Filter Examples and Aggregate operators useful. If you supply more information on what you want to do, we can give you more detailed information.

Regards, Marius

blue534

hi, marius thanks for your answer. i want to tell you what i want to do. i have an excel file. there are three columns in this file. 1 column is about the city location names of an company, other coloumn is about the selling amounts of the product. and other column is about the dates of these sellings. and i want to analyse these details in OLAP. for example, selling amounts for locations or most less selling dates in dates, etc.. can you tell me please how can i do it? and also i need to show with graphics too. thank you much...

MariusHelf

Hi,

below I provided an example process which displays the product sellings by storeId, and the product sellings per date, sorted by sellings.

The most important operator here is Aggregate. Here you can define one or more grouping attributes, e.g. the storeId, or in your case the country, and aggregation functions, e.g. sum(amount), which means that for each store the product sellings are summed up.

Hope this helps!
Best, Marius

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.2.006">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="5.2.006" expanded="true" name="Process">
    <process expanded="true" height="670" width="727">
      <operator activated="true" class="generate_sales_data" compatibility="5.2.006" expanded="true" height="60" name="Generate Sales Data" width="90" x="45" y="30"/>
      <operator activated="true" class="select_attributes" compatibility="5.2.006" expanded="true" height="76" name="Select Attributes" width="90" x="179" y="30">
        <parameter key="attribute_filter_type" value="subset"/>
        <parameter key="attributes" value="|amount|store_id|date"/>
        <parameter key="include_special_attributes" value="true"/>
      </operator>
      <operator activated="true" class="multiply" compatibility="5.2.006" expanded="true" height="112" name="Multiply" width="90" x="313" y="30"/>
      <operator activated="true" class="aggregate" compatibility="5.2.006" expanded="true" height="76" name="Aggregate (2)" width="90" x="447" y="210">
        <list key="aggregation_attributes">
          <parameter key="amount" value="sum"/>
        </list>
        <parameter key="group_by_attributes" value="|date"/>
      </operator>
      <operator activated="true" class="sort" compatibility="5.2.006" expanded="true" height="76" name="Sort" width="90" x="581" y="210">
        <parameter key="attribute_name" value="sum(amount)"/>
      </operator>
      <operator activated="true" class="aggregate" compatibility="5.2.006" expanded="true" height="76" name="Aggregate" width="90" x="447" y="75">
        <list key="aggregation_attributes">
          <parameter key="amount" value="sum"/>
        </list>
        <parameter key="group_by_attributes" value="|store_id"/>
      </operator>
      <connect from_op="Generate Sales Data" from_port="output" to_op="Select Attributes" to_port="example set input"/>
      <connect from_op="Select Attributes" from_port="example set output" to_op="Multiply" to_port="input"/>
      <connect from_op="Multiply" from_port="output 1" to_port="result 1"/>
      <connect from_op="Multiply" from_port="output 2" to_op="Aggregate" to_port="example set input"/>
      <connect from_op="Multiply" from_port="output 3" to_op="Aggregate (2)" to_port="example set input"/>
      <connect from_op="Aggregate (2)" from_port="example set output" to_op="Sort" to_port="example set input"/>
      <connect from_op="Sort" from_port="example set output" to_port="result 3"/>
      <connect from_op="Aggregate" from_port="example set output" to_port="result 2"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
      <portSpacing port="sink_result 3" spacing="0"/>
      <portSpacing port="sink_result 4" spacing="0"/>
    </process>
  </operator>
</process>

blue534

hi Marius
thanks for help. but i have no idea about codes. can i do this example in rapidminer by clicking icons ? sory for my english

MariusHelf

Hi, please read this post for instructions on how to use my xml code: http://rapid-i.com/rapidforum/index.php/topic,4654.0.html

blue534

dear marius, i did it but after that i cant find how to import them from excel. i think i need a book about this programme. is there any book? its very nice programme but i dont understand why it is so complicated....

MariusHelf

In the link provided in my signature you find links to video tutorials. A book is planned, please find the details at http://rapidminerbook.com/ .

Quick Links

Upcoming Events

Advancing power electronics design with Simcenter PSIM and High-Performance Computing
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Getting Started with Faster Motor Building in Simcenter Simlab
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Practical hybrid solver workflows in Simcenter Feko
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…

View all community events