Power Pivot Workbook with Cube AS DATASOURCE

Question

Hi,

Iam using a workbook having datasource as cube.

But my CUbe doesnt have fact Data, So my pivot table Rowlables and Column Labels Data is not showing.\

How make this work??

Thank you

Answer 1

Hi,

 Just drag the required columns to row labels and column labels areas appropriately. To learn more on how to import data from a cube to power pivot follow below link.

http://technet.microsoft.com/en-us/library/gg399165.aspx#importcube

We can't create a cube with out selecting a measure table.I am assuming you have created a cube by selecting a dimension table as measure table. We can't analyze much unless we have fact table.But we can represet them as row labels/column labels just by dragging them to row labels and column labels areas as required.

============================

Please mark as answer if helpful

Answer 2

Hi,

Thank you for the reply..

Iam having four dims and one fact table..

But still if i have values in fact table then only my row labels/column labels are coming in workbook.

Pls help me.

thank you

Answer 3

Hi Krishna_ece,

It seems that you are not using PowerPivot but common Excel workbook, you can click the Insert tab on the menu, then insert a PivotTable, then you can drag the field from PivotTableFiled into PivotTable.

If the issue still exist, please feel free to let us know.

Thanks,

---

Challen Fu

TechNet Community Support

Answer 4

Hi Challen,

Iam not using power pivot window launch.

Iam using cube in existing excel workbook and publishing in sharepoint.

Will this workbook have all the features of Power Pivot like vertipaque,in-memory am i missing anything?

Suggest me pls

Thank you

Answer 5

Hi krishna_ece,

No, you cannot use many excellent feature that belong to PowerPivot, such as: PowerPivot Gallery, Slicer and Vertipaq engine.

---

Challen Fu

TechNet Community Support

Answer 6

Hi Challen,

Mr Sachin_100 threaded me Saying vertipaq engine and in-memory available in excel workbook.

Below is the one he posted..

Whenever you create a pivot chart/pivot table in excel (data=> analysis services), excel will send queries to the model you  have deployed in  SQL Serevr analysis services instance. It uses the vertipaq engine, in-memory stuff for calculations. You can see this by opening profiler on sql server instance to which your model is deployed.

As I said, vertipaq is a in-memory engine, means your data should fit in memory. So you can work with the data that fit in your RAM.

Is this right?

Thank you

Answer 7

Hi Challen,

I need your comments pls.

thank you

Answer 8

"Whenever you create a pivot chart/pivot table in excel (data=> analysis services), excel will send queries to the model you  have deployed in  SQL Serevr analysis services instance. It uses the vertipaq engine, in-memory stuff for calculations. You can see this by opening profiler on sql server instance to which your model is deployed.

As I said, vertipaq is a in-memory engine, means your data should fit in memory. So you can work with the data that fit in your RAM."

Hi Krishna,

I told the above statement in the context of tabular model which you develop in SSDS in vertipaq mode either directly/by importing from power pivot. Then if you connect to that model from excel, it will use vertipaq engine. You can't develop a multi dimensional model/cube in vertipaq mode. So it won't use vertipaq engine when you are connecting to it.

In that thread we were discussing about power pivot work book. So I gave the above reply. Hope this helps.

=====================================

Answer 9

yes, Sachin_100 is correct, actually, when you install Analysis Sevices, you must choose from one of three server modes: Multidimensional mode, Tabular mode, and PowerPivot for SharePoint mode. They differ in the way they store data, how they use memory, and the engine they use to retrieve data for queries. Tabular mode uses the same VertiPaq Engine as PowerPivot for SharePoint mode.

---

Challen Fu

TechNet Community Support

Answer 10

Hi Challen,

Installing Analysis services mean when i install i configured Power Pivot for Sharepoint this created instances for me on alaysis services.

This is sufficient right ..

Thank you

Answer 11

Hi,

Please check the below links to install analysis services in multi-dimensional and tabular modes.

Install analysis services in Multi dimensional mode

http://msdn.microsoft.com/en-us/library/ms143708(v=sql.110).aspx

Install analysis services in Tabular mode (new in sql 2012)

http://msdn.microsoft.com/en-us/library/hh231722(v=sql.110).aspx

To create tabular models from power pivot models you need analysis services to be installed in tabular mode.

========================

Please mark as answer if kelpful

Answer 12

Hi Sachin,

I need not Configure Power Pivot for Sql server right?

As you said installing analysis services in multi dim mode is enough right?

Thank you