Kylin auth is basic authentication, so you need to do basic authentication in .net way.
maybe this link could help http://www.asp.net/web-api/overview/security/basic-authentication On Thu, Nov 12, 2015 at 3:48 PM, Indiradevi Gorijavolu < [email protected]> wrote: > I have little bit knowledge in .net.so I tried to write code in .net. But > it is showing some errors. > my kylin cube in VMware so how should we can give authorization? > Please send me exact code. > Please check my below query. Please find attachment also. > > protected void ASPxButton1_Click(object sender, EventArgs e) > { > //Page.ClientScript.RegisterStartupScript(this.GetType(), > "JsFunc", "alert('Hello!')", true); > // $.ajaxSetup({ > // headers: { 'Authorization': "Basic eWFu**********X***ZA==", > 'Content-Type': 'application/json;charset=utf-8' } // use your own > authorization code here > //}); > var request = $.ajax({ > url: "http://192.168.75.131:7070/kylin/api/query";, > type: "POST", > data: '{"sql":"select count(*) from > diemp;","offset":0,"limit":50000,"acceptPartial":true,"project":"testproj"}', > dataType: "json" > }); > request.done(function( msg ) { > alert(msg); > }); > request.fail(function( jqXHR, textStatus ) { > alert( "Request failed: " + textStatus ); > }); > } > } > > > -----Original Message----- > From: Luke Han [mailto:[email protected]] > Sent: Thursday, November 12, 2015 6:53 AM > To: [email protected] > Subject: Re: Refresh setting tab > > Please refer to how JavaScript to interactive with Kylin Services: > > http://kylin.incubator.apache.org/docs/howto/howto_use_restapi_in_js.html > > It should not too hard to write .net one with same approach. > > Thanks. > > > Best Regards! > --------------------- > > Luke Han > > On Thu, Nov 12, 2015 at 12:43 AM, Indiradevi Gorijavolu < > [email protected]> wrote: > > > I checked restapi.but I did not understand. > > > > Actually my scenario is I have .net application.in that .net > > application calling mdx queries.so I am binding result in grid. > > Same thing how is it possible here? > > > > -----Original Message----- > > From: Jian Zhong [mailto:[email protected]] > > Sent: Wednesday, November 11, 2015 2:49 PM > > To: [email protected] > > Subject: Re: Refresh setting tab > > > > 1) data will be store in hbase.we need to use Cube Metadata to build > > cuboids. > > > > 2) your sql will map to data in hbase. Cube will desc the necessary > > metadata like dimension,measure,rowkey...Build cube will build all > > cuboids for you. > > > > 3) check this API see how to use Kylin API > > http://kylin.incubator.apache.org/docs/howto/howto_use_restapi.html > > > > also here's a link about kylin olap engine > > http://www.slideshare.net/lukehan/kylin-olap-engine-tour > > > > > > On Wed, Nov 11, 2015 at 3:28 PM, Indiradevi Gorijavolu < > > [email protected]> wrote: > > > > > Finally successfully created cube,and quried data also.i observed > > > some difference in duration between hive and kylin. > > > > > > Here I have some questions. > > > 1)after cube build ,cube size showing 1kb only.wheere data will be > > > sit after cube build means does it is not stored in cube? > > > 2)after cube build, when we queried data, where it will retrieving > > > data like from tables or cube? If tables, what is the use of > > > building cube?(In BI, after cube processing data will be stored in > > > cube only like aggregate data, in kylin it is not showing cube size) > > > > > > 3)i need small code,how to call to kylin cubes in asp.net? I tried > > > some blogs, did not understand. Please give me sample code. > > > > > > > > > -----Original Message----- > > > From: Jian Zhong [mailto:[email protected]] > > > Sent: Wednesday, November 11, 2015 8:12 AM > > > To: [email protected] > > > Subject: Re: Refresh setting tab > > > > > > you need to build your cube first, when cube is enable you can > > > query.when disable, you can't query. > > > > > > if you never build your cube successfully, you can't enable your cube. > > > > > > about how to build cube check this > > > http://kylin.incubator.apache.org/docs/tutorial/cube_build_job.html > > > > > > On Wed, Nov 11, 2015 at 4:03 AM, Indiradevi Gorijavolu < > > > [email protected]> wrote: > > > > > > > I am successfully create job.but status is disable.does we need to > > > > enable cube or not required? > > > > > > > > When I enableing cube,I am getting some errors.please find > > attachehment. > > > > > > > > After cube build, do we need to run jobs also or not required? > > > > > > > > Please give me some guidense. > > > > > > > > -----Original Message----- > > > > From: Indiradevi Gorijavolu [mailto:[email protected]] > > > > Sent: Tuesday, November 10, 2015 5:39 PM > > > > To: [email protected] > > > > Subject: RE: Refresh setting tab > > > > > > > > I am successfully create cube. But this cube status is in > > > > diasable.i tried to enable, it is not enabling. > > > > > > > > Please suggest me, what I am doing wrong? > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Luke Han [mailto:[email protected]] > > > > Sent: Monday, November 09, 2015 7:55 PM > > > > To: [email protected] > > > > Subject: Re: Refresh setting tab > > > > > > > > Change those column's data type to same. > > > > > > > > > > > > Best Regards! > > > > --------------------- > > > > > > > > Luke Han > > > > > > > > On Mon, Nov 9, 2015 at 5:44 PM, Indiradevi Gorijavolu < > > > > [email protected]> wrote: > > > > > > > > > I downloaded v1.1 version. Now I am getting below error. What I > > > > > did wrong ,please suggest me. > > > > > > > > > > > > > > > Error Message > > > > > > > > > > Primary key DEFAULT.DIMEMP.EMPLOYEEKEY.tinyint are not > > > > > consistent with Foreign key > > > > > DEFAULT.FACTSALESQUOTA.EMPLOYEEKEY.smallint > > > > > > > > > > -----Original Message----- > > > > > From: Shaofeng Shi [mailto:[email protected]] > > > > > Sent: Sunday, November 08, 2015 8:11 PM > > > > > To: [email protected] > > > > > Subject: RE: Refresh setting tab > > > > > > > > > > please download v1.1 and try again > > > > > > > > > > Indiradevi Gorijavolu <[email protected]>编写： > > > > > > > > > > >Kylin version is apache kylin 1.0,browser is firefox 38.0.1. > > > > > > > > > > > >-----Original Message----- > > > > > >From: ShaoFeng Shi [mailto:[email protected]] > > > > > >Sent: Sunday, November 08, 2015 6:21 AM > > > > > >To: [email protected] > > > > > >Subject: Re: Refresh setting tab > > > > > > > > > > > >what's your kylin version and browser version? from the > > > > > >screenshot I see > > > > > there is JS error, looks like browser compatible issue. > > > > > > > > > > > >2015-11-08 8:36 GMT+08:00 Luke Han <[email protected]>: > > > > > > > > > > > >> Well, have you tried here? > > > > > >> > > > > > >> http://kylin.incubator.apache.org/docs/ > > > > > >> > > > > > >> Thanks. > > > > > >> > > > > > >> > > > > > >> Best Regards! > > > > > >> --------------------- > > > > > >> > > > > > >> Luke Han > > > > > >> > > > > > >> On Sun, Nov 8, 2015 at 3:00 AM, Indiradevi Gorijavolu < > > > > > >> [email protected]> wrote: > > > > > >> > > > > > >> > I tried with without lookup table,but same thing is happing. > > > > > >> > > > > > > >> > Do you have any documents step by step for creating cubes? > > > > > >> > if you have please share me. > > > > > >> > > > > > > >> > > > > > > >> > -----Original Message----- > > > > > >> > From: yu feng [mailto:[email protected]] > > > > > >> > Sent: Saturday, November 07, 2015 4:44 PM > > > > > >> > To: [email protected] > > > > > >> > Subject: Re: Refresh setting tab > > > > > >> > > > > > > >> > I do not know the problem about the button disable, but I > > > > > >> > always build cube without any lookup table, all dimensions > > > > > >> > and measures are in one table, It can works... > > > > > >> > > > > > > >> > 2015-11-07 17:08 GMT+08:00, Indiradevi Gorijavolu < > > > > > >> [email protected] > > > > > >> > >: > > > > > >> > > I added one dimensation in dimensation tab,still refresh > > > > > >> > >settings tab in next button is not enabled. > > > > > >> > > > > > > > >> > > Here I got one question.in datamodel tab ,is it mandatory > > > > > >> > > to add lookup table? > > > > > >> > > > > > > > >> > > Please find attached screenshot. > > > > > >> > > > > > > > >> > > > > > > > >> > > -----Original Message----- > > > > > >> > > From: Luke Han [mailto:[email protected]] > > > > > >> > > Sent: Friday, November 06, 2015 8:07 PM > > > > > >> > > To: [email protected] > > > > > >> > > Subject: Re: Refresh setting tab > > > > > >> > > > > > > > >> > > Please send screenshot as attachment, we can't see it > > > > > >> > > directly from > > > > > >> mail. > > > > > >> > > > > > > > >> > > Thanks. > > > > > >> > > > > > > > >> > > > > > > > >> > > Best Regards! > > > > > >> > > --------------------- > > > > > >> > > > > > > > >> > > Luke Han > > > > > >> > > > > > > > >> > > On Fri, Nov 6, 2015 at 9:54 PM, Indiradevi Gorijavolu < > > > > > >> > > [email protected]> wrote: > > > > > >> > > > > > > > >> > >> HI, > > > > > >> > >> > > > > > >> > >> > > > > > >> > >> > > > > > >> > >> I created one dimension and fact table in hive tables. > > > > > >> > >> > > > > > >> > >> in data model tab, added lookup table as dimension table. > > > > > >> > >> > > > > > >> > >> in dimension tab, i did not add anything. > > > > > >> > >> > > > > > >> > >> measures tab ,added one fact column with sum. > > > > > >> > >> > > > > > >> > >> after filter tab, Refresh setting tab next button is > > > > > >> > >> not > > > > enabling. > > > > > >> > >> Could you please check ,what i did mistake. Please let > > > > > >> > >> me > > know. > > > > > >> > >> > > > > > >> > >> > > > > > >> > >> > > > > > >> > >> And one thing could you please provide me ,kylin cube > > > > > >> > >> creation document. I read blogs did not find exact > solution. > > > > > >> > >> > > > > > >> > >> > > > > > >> > >> ------------------------------ > > > > > >> > >> > > > > > >> > >> This electronic transmission and any documents > > > > > >> > >> accompanying this electronic transmission contain > > > > > >> > >> confidential information belonging to the sender. This > > > > > >> > >> information may contain confidential health information > > > > > >> > >> that is legally > > > privileged. > > > > > >> > >> The information is intended only for the use of the > > > > > >> > >> individual or entity named above. The authorized > > > > > >> > >> recipient of this transmission is prohibited from > > > > > >> > >> disclosing this information to any other party unless > > > > > >> > >> required to do so by law or regulation and is required > > > > > >> > >> to delete or destroy the information after its > > > > > stated need has been fulfilled. > > > > > >> > >> If you are not the intended recipient, you are hereby > > > > > >> > >> notified that any disclosure, copying, distribution or > > > > > >> > >> the taking of any action in reliance on or regarding the > > > > > >> > >> contents of this electronically transmitted information > > > > > >> > >> is > > > strictly prohibited. > > > > > >> > >> If you have received this E-mail in error, please notify > > > > > >> > >> the sender and delete this message immediately. > > > > > >> > >> > > > > > >> > > > > > > > >> > > _________________________________________________________ > > > > > >> > > __ __ __ __ _ ____ This electronic transmission and any > > > > > >> > > documents accompanying this electronic transmission > > > > > >> > > contain confidential information belonging to the sender. > > > > > >> > > This information may contain confidential health > > > > > >> > > information that is legally privileged. The information > > > > > >> > > is intended only for the use of the individual or entity > named above. > > > > > >> > > The authorized recipient of this transmission is > > > > > >> > > prohibited from disclosing this information to any other > > > > > >> > > party unless required to do so by law or regulation and > > > > > >> > > is required to delete or destroy the information after > > > > > >> > > its stated need has been fulfilled. If you are not the > > > > > >> > > intended recipient, you are hereby notified that any > > > > > >> > > disclosure, copying, distribution or the taking of any > > > > > >> > > action in reliance on or regarding the contents of this > > > > > >> > > electronically transmitted > > > information is strictly prohibited. > > > > > >> > > If you have received this E-mail in error, > > > > > >> > please notify the sender and delete this message immediately. > > > > > >> > > > > > > > >> > > > > > > >> > ___________________________________________________________ > > > > > >> > __ __ __ __ _ __ This electronic transmission and any > > > > > >> > documents accompanying this electronic transmission contain > > > > > >> > confidential information belonging to the sender. This > > > > > >> > information may contain confidential health information > > > > > >> that > > > > > >> > is legally privileged. The information is intended only > > > > > >> > for the use of > > > > > >> the > > > > > >> > individual or entity named above. The authorized recipient > > > > > >> > of this transmission is prohibited from disclosing this > > > > > >> > information to any other party unless required to do so by > > > > > >> > law or regulation and is required to delete or destroy the > > > > > >> > information after its stated need has been fulfilled. If > > > > > >> > you are not the intended recipient, you are hereby > > > > > >> notified > > > > > >> > that any disclosure, copying, distribution or the taking of > > > > > >> > any action in reliance on or regarding the contents of this > > > > > >> > electronically transmitted information is strictly prohibited. > > > > > >> > If you have received this E-mail in error, please notify > > > > > >> > the sender and > > > > > delete this message immediately. > > > > > >> > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > >-- > > > > > >Best regards, > > > > > > > > > > > >Shaofeng Shi > > > > > > > > > > > >_______________________________________________________________ > > > > > >__ __ __ _ This electronic transmission and any documents > > > > > >accompanying this > > > > > electronic transmission contain confidential information > > > > > belonging to the sender. This information may contain > > > > > confidential health information that is legally privileged. The > > > > > information is intended only for the use of the individual or > entity named above. > > > > > The authorized recipient of this transmission is prohibited from > > > > > disclosing this information to any other party unless required > > > > > to do so by law or regulation and is required to delete or > > > > > destroy the information after its stated need has been > > > > > fulfilled. If you are not the intended recipient, you are > > > > > hereby notified that any disclosure, copying, distribution or > > > > > the taking of any action in reliance on or regarding the > > > > > contents of this electronically transmitted information is > > > > > strictly prohibited. If you have received this E-mail in error, > > > > please notify the sender and delete this message immediately. > > > > > > > > > > > > > __________________________________________________________________ > > > > __ __ This electronic transmission and any documents accompanying > > > > this electronic transmission contain confidential information > > > > belonging to the sender. This information may contain > > > > confidential health information that is legally privileged. The > > > > information is intended only for the use of the individual or > > > > entity named above. The authorized recipient of this transmission > > > > is prohibited from disclosing this information to any other party > > > > unless required to do so by law or regulation and is required to > > > > delete or destroy the information after its stated need has been > > > > fulfilled. If you are not the intended recipient, you are hereby > > > > notified that any disclosure, copying, distribution or the taking > > > > of any action in reliance on or regarding the contents of this > > > > electronically transmitted information is strictly prohibited. If > > > > you have received this E-mail in error, > > > please notify the sender and delete this message immediately. > > > > > > > > > > ____________________________________________________________________ > > > __ This electronic transmission and any documents accompanying this > > > electronic transmission contain confidential information belonging > > > to the sender. This information may contain confidential health > > > information that is legally privileged. The information is intended > > > only for the use of the individual or entity named above. The > > > authorized recipient of this transmission is prohibited from > > > disclosing this information to any other party unless required to do > > > so by law or regulation and is required to delete or destroy the > > > information after its stated need has been fulfilled. If you are > > > not the intended recipient, you are hereby notified that any > > > disclosure, copying, distribution or the taking of any action in > > > reliance on or regarding the contents of this electronically > > > transmitted information is strictly prohibited. If you have > > > received this E-mail in error, > > please notify the sender and delete this message immediately. > > > > > >
