Data picker value is not being displayed ?!

Malav Shelat

Hello All,

 

I am not able to display value using Data picker, here are the steps i have done from start, 

let me know if i am missing on some part to help rectify this.

 

Step 1: Created a new Entity (SalesReport)

 

Step 2: Created a cube name SalesCube (Using SalesReport in structure)

 

 

Step 3: Created Rule and used Data picker Syntax to fetch the summarized Sales Value from Actual Sales Cube with physical name V003

 

Here is the image of all cube with physical name:

 

and below is what i had mentioned in Rule

 

 

Step 4: Created Dataview with Layout as Follows:

 

Axes: SalesReport,

Data:

   DataSelection: SalesCube, Functions: SalesRpt (<-The same rule which is created above)

 

Step 5: Value mentioned in Data Picker is not being Displayed

 

Can you please guide me in where i am making mistake, so that i can rectify it and get the desired output.

 

Regards,

Malav

Unknown

Hi Malev,

 

just noticed you are running the datapicker on a "Big Data" cube - can you try using a standard cube?

Not sure which version you are on but BigData cubes are experimental on current BOARD versions so that might be the cause of the datapicker not working

Kind Regards
Michele

Previous Member

Hi Michele Roscelli

 

I am using Board version 10.1.4 , I had created database using XLS file through Data Fast Track option in board, I tried selecting Standard cube and instantly my cube size is reflecting as 0 KB, i also tried selecting in-Memory option as well but it did not work , still i am finding the resolution for this.

 

could you please help a little more on this ?

 

Kind regards,

Malav

Unknown

Hi Malav Shelat

 

When restructuring a cube (changing structure or type) the data in the cube will be cleared and you need to reload it.

 

 

 

When you run the fast track, make sure you untick the "BigData" option when loading the data (see below screenshot)

If you want to extend the model with datapicker, rules, and extra functionalities, I would suggest that you create a datamodel from scratch (without using the fasttrack) and then convert the XLS data into a CSV file, and load it via ASCII protocol in the datareader section.

The Fasttrack is useful to quickly load data into a Board Datamodel but is not ideal if you want to extend what you created to a "project" level. E.g. loading an XLS file won't produce data-reader protocols if you need to reload the data.

 

Let me know if this helps

Thanks
Michele

Previous Member

Hi Michele Roscelli, 

 

Your solution worked completely perfect. thank you so much for your kind help.

 

Thanks again,

Malav