7/28/12

Version 1.4.5 supports full set of query-scoped calculated items

Since version 1.4.5 you can create Cell Calculations and Named Sets.

Named Set

Define Set expression.


Drag and drop created set to row or column area.

Cell Calculation

Define cell calculation set in SCOPE statement format. Define set expression.


Also you can set font and colors for cell calculations.



7/19/12

How to add and use Calculated Members


PivotGrid allow create and use query-scoped calculated members.

To add new calculated member push the button “Add Calculated Member” on the query designer.


Set calculated member name and expression. When you write expression you can drag and drop olap items from the cube browser and from the PivotGrid.


You can set font, back color and fore color for calculated member.


Color” button replaces a color expression with value that you choose in the Color dialog. “Add color” adds color value to expression in place of the cursor or replace selected text with color value. “Template” button replaces expression with mdx template that sets different color for negative, positive, zero and null data values. “Font” buttons sets font name, font size and font flags expessions.



After you have created the calculated member you can drag it to the query designer panes or to the PivotGrid areas. Also you can select the calculated member in the hierarchy filter.


Calculated member properties that you can define:

  • Name
  • Expression
  • Parent hierarchy
  • Parent member
  • Fore color
  • Back Color
  • Font name
  • Font size
  • Font flags
  • Non-empty behavior
  • Solve order


Using calculated member that has parent hierarchy other than Measures

Set parent member for calculated member that has parent hierarchy other than Measures. In other case you will not be able to drilldown top level member.

You will see your calculated member in hierarchy tree only if you work with Microsoft SQL Server 2008 R2 Analysis Services. If you have Microsoft SQL Server 2005 Analysis Services or Microsoft SQL Server 2008 Analysis Services you can use your calculated member only in hierarchy filter.







7/7/12

How to execute MDX query in PivotGrid Designer

PivotGrid Designer allow execute MDX query and browse result in PivotGrid.

To execute your MDX query select MDX tab and push Clear button.



Type MDX query and push Execute button or press F5.


The PivotGrid tab will open and you will see query result in PivotGrid.

If errors occur the Response Errors tab will open and errors will be listed there. You can locate error position in MDX by clicking Location link or double click error row.


In case of error you can return to last successful result. Select PivotGrid tab and press Return To Last Successful Result button. Your query text and PivotGrid appearance will return to state when command execution was successful.

6/30/12

How to integrate your controls with Kropka Olap Components


If you have your set of control for visualization Olap data you can add some of Kropka Olap control to you application and integrate them together.

Drag-and-Drop integration

There are info interfaces in Kropka.Data.Info namespace (Kropka.Data assembly), which are designed to support Drag-and-Drop operations.
These interfaces are:

  • ICubeInfo
  • IDimensionInfo
  • IHierarchyInfo
  • IKpiGoalInfo
  • IKpiInfo
  • IKpiStatusInfo
  • IKpiTrendInfo
  • IKpiValueInfo
  • ILevelInfo
  • IMeasureGroupInfo
  • IMeasureInfo
  • IMeasureSetInfo
  • IMeasuresInfo
  • IMemberInfo
  • ISetInfo

Most of them have two properties:
  • UniqueName - the unique name of OLAP data or metadata item. For example, [Date].[Calendar].
  • CubeName – name of the cube (without brackets) which items belongs to. For example, Adventure Works).

Kropka Olap Components as drop targets

Implement one of the Kropka.Data.Info interfaces in your class that will be the DataObject in drag-and-drop operation.
using Kropka.Data.Info;
class MyDragedObject: IHierarchyInfo
{

    ...

    string IOlapInfo.CubeName
    {
        get { return this.MyMethodToGetCubeName(); }
    }

    string IOlapInfo.UniqueName
    {
        get { return this.MyMethodToGetUniqueName(); }
    }

}

Or create simple class for drag-and-drop operation purpose.
    class DragedHierarchy: IHierarchyInfo
    {
        private string cubeName = null;
        private string uniqueName = null;

        public string CubeName
        {
            get { return this.cubeName; }
            set { this.cubeName = value; }
        }

        public string UniqueName
        {
            get { return this.uniqueName; }
            set { this.uniqueName = value; }
        }
    }
And add it when you will initiates a drag-and-drop operation.

private void StartDragHierarchy()
{
    DataObject dataObject = new DataObject();

    ...

    DragedHierarchy dragedHierarchy = new DragedHierarchy();
    dragedHierarchy.UniqueName = "[Date].[Calendar]";
    dragedHierarchy.CubeName = "Adventure Works";

    dataObject.SetData(typeof(Kropka.Data.Info.IOlapInfo), metadataNodeInfo);

    ...

    this.MyControl.DoDragDrop(dataObject, DragDropEffects.Copy);
}

Kropka Olap Components as drag source

When you handle drag-and-drop events in your control check whether the transferred data is desired Kropka.Data.Info interface.
protected override void OnDragDrop(DragEventArgs drgevent)
{
    if (drgevent.Data.GetDataPresent(typeof(Kropka.Data.Info.IOlapInfo)))
    {
        Kropka.Data.Info.IOlapInfo olapInfo = drgevent.Data.GetData(typeof(Kropka.Data.Info.IOlapInfo)) as Kropka.Data.Info.IOlapInfo;
        if (olapInfo is Kropka.Data.Info.IHierarchyInfo)
        {
            ...
        }
    }
 }


6/14/12

Three windows form controls

Kropka Olap Design” controls:


CubeMetaBrowser




Features:
  • Browses cube structure.
  • Source of drag-and-drop operation for other controls.

PivotGrid


Features:
  • Shows cube data.
  • Allows to drag-and-drop items to and from different area.
  • Allows expanding, collapse, filtering and slicing data.
  • Shows member and cell properties.

PivotGridQueryDesigner


Features:
  • Helps design PivotGrid query in more simple form.