first steps -

[alexhaifa]

Hello,

I have a table with joins, it will be the fact table.

with these information:

supplier - client - product - date1 - date2 - date3 - date4 - qtd1 - qtd2 - qtd3 - qtd4

I am not getting to display the information in the grid.

supplier
client
products

are my dimensions

the other fields only the column.

What are the first steps to display the rows? where should I start?

Thanks very much

[AlexZencovich]

At first you should define dimensions (supplier, client, product) and measures (qtd1 etc) right.

I guess you miss something in dimensions definition (missed Key-Lookup fields data most common error)

Please see demo app source code for that. Also, you may find useful information in Users guide (come with trial package).

[alexhaifa]

ok, I took a look at what you said.

But something I must be doing that my dimension is not appearing.

I am gonna relate my steps:

First I placed my fact table named Fact_sales with joins - I will not have other dataset for each dimmension.

I placed a Pivotcube - pivotmap - grid - column - dimtoobar - coltoolbar - measure.

I linked PivotMap to Pivotcube and the others to PivotMap.

I create two dimension in PivotCube

From the table fact I have a field named client

so, in dimension[0]

Dataset = Fact_sales
Fieldname= client
keyfield = client
lookupfield = client
displayname = clientes

it doesn't appear in my dimesiom tool , why?

something wrong here?

[alexhaifa]

Please, could you take a look at my code?

Unfortunately I am not being able to identify the error.

http://www.infosoftlanguages.com.br/arq ... stoque.zip

there are in this file .pas .dfm .dpr an access database


Thanks very much

[AlexZencovich]

Are you set PivotCube.Active := True?

Your code looks like nothing happened when you run a form.

[alexhaifa]

Yeah, you are right!

it was missing PivotCube.active := true