I cannot post code due to security compliance.

I have taken another table and joined to main table and used related function and that solved the issue.

but not able to fix...

I did the process All. I double checked the both column data types. Every thing looks good.

You asked about structure. Hope below information make sense to you.

I have a TableFact...

I think you should provide access to RepFolder first and it will be inherited to reports on that folder.

If you want to modify the reports security then you have to...

Sorry. If I didnt give proper information.

I want to do it in the model. Not using query.

I have seen an online link but its giving error at the final step.

http://www.sqljason.com/2013/01/group-multiple-rows-to-single-delimited.html

I...

I want the above result using DAX formulas in PowerPivot.

I imported the table and I have the column as I specified above.

Source is Oracle.

I understand now what are you telling. I thought that is only for Tabular models. We can do that for MultiDim also.

Thank a lot Paul for your great help.

Do you think XMLA is easier than SQL. Does it really helpful for oracle data sources?

Only concern is, Neither I nor my clients have XMLA skills. Every body here are...

I think I am close to what I want to achieve.

Using Execute SQL task, I check the last_data_update from system table and take that date and keep it in...

Thanks a lot.

I am able to work with it.

yeah 🙂 its hard way and this is how the requirement is.

There is another challenge. can I use the variable...

Its now working fine. Thank you.

now the next challenge, Can I read this variable in Data Flow source tasks.

I created a OLEDB connection to oracle database.

I want to take...

No luck after trying with string. same error is coming.

It looks like helpful.

But I tried this approach. I have the below query and I am getting the error "Unsupported data type on result set binding last_data_update"

I pulled the execute...

mm7861 (5/20/2015)

---

Hi all,

- Reporting Properties - I know in Multidimensional you could set Reporting Properties so that when you hover over a dimension in a pivot table, you can see...

Martin Schoombee (5/15/2015)

---

Not true...the issue experienced by the...

when you run the project, it first processes Dimensions, then Cube.

what is the data source you are using. If its other than SQL Server, you will be getting this kind...