PowerBI site is what I think I am using now. It only has PowerPivot gallery and we can really schedule the PowerPivot reports here. also we can create performance Point...

I used the parameters in PowerQuery using the below link. It is really what I want but Its not working on SharePoint BI site. I want this to be used...

mm7861 (5/7/2015)

---

I've taken a slightly different approach.

I created a calculated column that reversed the sign for the total column if the type ='C'. I then created a measure for this...

I dont think there is an option to customize the Pivot table. you can't control the pivot table columns and rows. It automatically takes the second column and repeats for...

I am assuming that you have 3 different columns A, B and C in Type Dimension.

I would prefer to do it at Tabular model using DAX formula.

I create new...

May be on Server, there might be a limitation on records that you need to increase the Dimension records count.

OLAP\Query\DefaultDrillThroughMaxRows

and also the RAM memory size also you may need to...

k_kasa78 (5/1/2015)

---

1.In SSIS 2012 we have option. Below link as good info.

http://www.mssqltips.com/sqlservertip/3013/introduction-to-the-dimension-processing-destination-in-ssis-2012/

2.For XMLA processing and SSIS 2008 . follow below steps

2.1Build XMLA script using script Task Editor ...

k_kasa78 (5/1/2015)

---

1.In SSIS 2012 we have option. Below link as good info.

http://www.mssqltips.com/sqlservertip/3013/introduction-to-the-dimension-processing-destination-in-ssis-2012/

2.For XMLA processing and SSIS 2008 . follow below steps

2.1Build XMLA script using script Task Editor ...

Martin Schoombee (4/10/2015)

---

VRT (4/10/2015)

---

Thank you for your reply Martin.

I am already using this document as reference and worked on this ROLAP cube. I was really happy when I first see...

PB_BI (4/10/2015)

---

xsevensinzx (4/10/2015)

---

PB_BI (4/9/2015)

---

Yes, go out and spend $600,000 per core to solve your problem...

Martin Schoombee (4/8/2015)

---

Although old, the following article may help you to optimize a ROLAP cube (or at least point out some things that impact performance): http://download.microsoft.com/download/1/6/F/16F258DF-BB38-471B-AC4F-EC126DC9FE9B/SSAS%20ROLAP%20for%20SQL%20Server.docx

With that being said, have...

I am not directly importing table. I am uisng a SQL like

Select * from Dimtable

where pk_id (select pk_id from factable where period between 20130101 and 20130131)

I am not...

Thanks for the reply.

I changed the datatype to Whole number and data format to whole Number.

It processed again and coverted the column to Number format but now we are getting...

Hi

Yes I applied attribute relations correctly.

Actually, I used named query in DSV file, we have location_code column based on that column I wrote a case statement.

Thanks a lot for your help.:-)

It worked. I created a physical measure with 0 value. Later in calculations, I override its value using MDX scope